Does anyone have a better way to do this conversion?
Using phpmyadmin, I create the table in MySQL to match the columns of data I have in my spreadsheet. Once the data is created in excel, I insert additional columns between each column to add the ( ," "," , ",); type notation. I then save the excel sheet as a text file in space-delimited format.
This give me a text file that I can load in my MySQL tables using phpmyadmin. The problem comes with the total width of the columns. After a total width of say around 200 charaters, the text file will wrap the rows of data and it becomes useless to incorporate into MySQL.
How does anyone else get around this problem or is there another solution I am unaware of?
David
