MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: Excel data to mysql database
Posted by: Devart Team
Date: March 12, 2010 07:45AM

You could use LOAD DATA INFILE command to import from CSV files. Excel can store data to CSV file.

LOAD DATA INFILE Syntax
http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Try visual Data Import tool in dbForge Studio for MySQL. It allows to import data from Excel, Excel 2007 and from other formats such CSV.

http://www.devart.com/dbforge/mysql/studio/download.html

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Excel data to mysql database
5181
nischala n
March 12, 2010 04:17AM
Re: Excel data to mysql database
3126
Devart Team
March 12, 2010 07:45AM
Re: Excel data to mysql database
2881
David West
March 13, 2010 01:33AM
Re: Excel data to mysql database
2562
Dmitry Narizhnykh
March 14, 2010 05:04PM
Re: Excel data to mysql database
2398
Damir Bulic
August 25, 2010 03:08AM
Re: Excel data to mysql database
1510
Thomas Frank
November 08, 2010 01:14PM


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.