need help loading data into mySQL

[reub77]

Is it possible to load data into a mySQL database using an .xls file? Or something similar? I think I have to convert it to a text file and then reformat the fields, but that would be a pain. Any ideas?

[kevinsequeira]

search for myodbc in the forums....
xl - > access -> mysql

reg
kevin

[toddmarx]

if you are using any Microsoft Office suite of Exel. You have the option to save the file as a CSV. Then once you do that. Go into your phpMyAdmin and use the CSV file to dump the data into the mysql database. It works. I had to do it a while back for a client that was using exel as thier database and wanted to upgrade and use php/mysql.

You will have to change the "terminate field by" are, but I cannto remember what it should be. Play around with it and you will eventually get it.

If you cant get it, send me a private message and we will work something out.

Hope that helps,
Todd