Mac OS 9.2 to MySQL

[ennok]

I want to upload data from an Mac OS-excel-sheet into a mySQL-DB.
Does anyone has experiences in doing that and knows how to export data from excel?
It must be different from just saving it as csv-format as mySQL can only understand data separated by quotation-marks and comma.

Thanks for your help.

 

[jimoblak]

Open your CSV file and do a find/replace on all field separators to turn them into...

','

Then do another find/replace to change line returns

\n

into

'\n'

This will encase all of your fields for easy import into MySQL.

You might also check out the MySQL forum on Tek-Tips.

- - picklefish - -
Why is everyone in this forum responding to me as picklefish?