Excel Data to MySql Database

Forum Moderators: open

Message Too Old, No Replies

Excel Data to MySql Database

How do I export MS Excel Data into MySql

erdy

4:56 pm on Feb 22, 2008 (gmt 0)

Hi,

does anyone have quick way of exporting data from a MS Excel file into a Mysql database?
I can see some free download applications on the net but wondered if there was a simpler way of doing it. i.e. exporting from Excel as a particular file format and then importing it into MySql?

Please let me know if you can help, I'm very new to MySql and somebody briefly mentioned to me that it was possible some time ago.

Regards

Erdy.

jtara

6:22 pm on Feb 22, 2008 (gmt 0)

CSV (comma-separated values), or better yet, MySQL's preferred text format, tab-separated values.

rocknbil

6:26 pm on Feb 22, 2008 (gmt 0)

Well, here is one way. You export the data in some delimited text format (tab, character) and import it using mysqlimport.

Documentation [dev.mysql.com]

For various reasons, it's preferable to use a script, but this should do it.