How to convert MS Excel format to My SQL?

[Chloe]

Greetings,

I have some data stored in MS Excel, and would like to convert it to My SQL format, is anyone out there know how to solve this? :wave:

 

thank you

[C1ay]

Greetings,

I have some data stored in MS Excel, and would like to convert it to My SQL format, is anyone out there know how to solve this? :rant:

 

thank you

Export your data to a delimited format and import it to a table in MySQL.

[Chloe]

Thank you for your help, I know the excel spreadsheet format can be save as .csv file, and If I have phpMyAdmin, so do you know the steps that export to phpMyAdmin?

[C1ay]

http://dev.mysql.com/doc/mysql/en/mysqlimport.html

[Chloe]

http://dev.mysql.com/doc/mysql/en/mysqlimport.html

 

thanks again Clay. I will look at this url.

 

I found another alternative too,

 

http://www.webthang.co.uk/tuts/tuts_dbase/convert/Pf/convert_pf.asp

 

http://www.webthang.co.uk/tuts/tuts_dbase/convert/Pf/convert2_pf.asp

 

if anyone out there have the same problem, feel free to look at one of this url posted.

[alexander]

or you could write a short script to do it in PHP, its pretty easy really, you open up an odbc connection to excell and a mysql connection, then you select all the stuff in the excell spreadsheet and put it in the appropriate places in your mysql database. makes for an easy and very bendable and customizable solution, so