Re: how to import excel file into mysql

[Devart Team]

Take advantage of Data Import tool in dbForge Studio 4.00 for MySQL. It allows to import from Excel, Excel 2007, from the text files and from other formats.

dbForge Studio for MySQL 4.00 beta is available for download. You can download a fully-functional 30day trial version at -
http://www.devart.com/news/2009/dbforgestudio400b.html

Also, to import from the text files, you could use LOAD DATA INFILE statement.
Here is an example -

Let's create a table -
CREATE TABLE table1 (id INT(11), data_column VARCHAR(20));

Data in the 'data.csv' -
1;text1
2;text2
3;text3

And our command -
mysql> LOAD DATA INFILE 'data.csv'
INTO TABLE table1
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';

Select data from table -
mysql> SELECT * FROM table1;

+------+-------------+
| id | data_column |
+------+-------------+
| 1 | text1 |
| 2 | text2 |
| 3 | text3 |
+------+-------------+
3 rows in set (0.00 sec)

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/