MySQL Forums
Forum List  »  Microsoft Access

Re: how to import excel file into mysql
Posted by: Devart Team
Date: December 29, 2009 02:24AM

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
10583
December 29, 2009 12:03AM
Re: how to import excel file into mysql
7684
December 29, 2009 02:24AM


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.