Re: how to import excel file into mysql
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/
Subject
Views
Written By
Posted
10958
December 29, 2009 12:03AM
Re: how to import excel file into mysql
8190
December 29, 2009 02:24AM
4502
December 30, 2009 07:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.