MySQL Forums :: Microsoft Access :: how to import excel file into mysql

Advanced Search

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 -

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' -

And our command -
mysql> LOAD DATA INFILE 'data.csv'

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

Options: ReplyQuote

Subject Views Written By Posted
how to import excel file into mysql 10540 kovuru amarnath 12/29/2009 12:03AM
Re: how to import excel file into mysql 7636 Devart Team 12/29/2009 02:24AM
Re: how to import excel file into mysql 4260 Dmitry Narizhnykh 12/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.