Excel Data to MySql Database

How do I export MS Excel Data into MySql

[erdy]

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]

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

[rocknbil]

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.