How to Import Excel Data into MySQL
I’ve been seriously busy for many months working on my latest project. A software program called Excel2MySQL available at excel2mysql.net
What is it? Like the name implies… it allows you to import Excel files into MySQL database tables.
IMHO nothing else is as easy, fast, or accurate… Nothing!
I stand behind that claim and I am prepared to take on all contrary opinions (including the common practice of using CSV files and the LOAD DATA command).
You can see a comparison to other products here: http://www.excel2mysql.net/compare.html
I’ve been doing SQL (DB2, Oracle, PostgreSQL, MySQL, MS SQL…) since 1990 and this is truly best in class software if you are using MySQL.
In any case, I welcome your feedback.