Skip navigation links

MySQL Forums :: Other Migration :: import from Excel to MySQL


Advanced Search

Re: import from Excel to MySQL
Posted by: Titus Hui ()
Date: March 07, 2009 11:33PM

Alcide Burato Wrote:
-------------------------------------------------------
> This is a little complex method, but i think could
> be interesting.
>
> You need:
>
> 1. MS Access
> 2. MySQL Connector/ODBC
>
> Step:
>
> 1. create a ODBC connection to the destination
> MySQL database.
> 2. Open MS Access and create a new access
> database.
> 3. Import the excel data creating a new table.
> 4. Export the new table just created selecting
> "Database ODBC()" from file Type list.
> 5. Select the ODBC connection related to the
> destination MySQL database.
>
> Bye!
> Alcide Burato


This is the most useful one as
you will have the table structure and data get imported.

No need to buy Navicat for import of excel file.

Thanks a lot!!

Options: ReplyQuote


Subject Views Written By Posted
import from Excel to MySQL 296948 m ds 09/10/2004 04:53AM
Re: import from Excel to MySQL 167364 Davorin Jelen 09/20/2004 07:19AM
But LOAD DATA does not take care of relationships 64706 Ashwin Kamath 10/15/2004 03:41AM
Re: But LOAD DATA does not take care of relationships 48038 Dana Henderson 10/15/2004 05:07AM
Re: import from Excel to MySQL 64761 Manish Sharma 08/18/2005 12:00AM
Re: import from Excel to MySQL 58569 tapan rath 09/05/2005 10:45PM
Re: import from Excel to MySQL after save it in txt format 45446 saurabh kumar 07/12/2007 10:17PM
Re: import from Excel to MySQL 31832 gandham ramesh 04/15/2008 04:14AM
Re: import from Excel to MySQL 46057 Dana Henderson 09/26/2004 02:30PM
Re: import from Excel to MySQL 33146 Thomas Schneider 02/01/2005 06:05AM
Re: import from Excel to MySQL 24698 Erwan Pianezza 01/25/2006 07:49AM
ESF Database Convert 24962 h qy 06/19/2006 09:02PM
Re: import from Excel to MySQL 21822 james zimmerman 04/11/2007 07:52PM
Re: import from Excel to MySQL 15077 Balamurugan Jagadeesan 05/17/2007 11:18AM
Re: import from Excel to MySQL 10759 mikel gorge 09/10/2008 08:32AM
Re: import from Excel to MySQL 15109 Raphael Mazar 07/07/2007 08:11AM
Re: import from Excel to MySQL 17120 Karanjkar Durgesh 10/08/2007 10:11AM
Re: import from Excel to MySQL 13200 john crane 11/04/2007 12:36PM
Re: import from Excel to MySQL 10891 Vu Mai 02/26/2008 03:43PM
Re: import from Excel to MySQL 14008 Vu Mai 02/26/2008 03:49PM
Re: import from Excel to MySQL 10480 Vu Mai 02/27/2008 05:32PM
Re: import from Excel to MySQL 10742 arat rana 03/19/2008 03:49AM
Re: import from Excel to MySQL 11098 frank Don 03/24/2008 05:58PM
Re: import from Excel to MySQL 6877 Iresh Patel 03/14/2009 07:55AM
Re: import from Excel to MySQL 12656 Alcide Burato 05/18/2008 08:55AM
Re: import from Excel to MySQL 9832 Titus Hui 03/07/2009 11:33PM
Re: import from Excel to MySQL 13087 yamen ajjour 07/07/2008 12:17AM
Re: import from Excel to MySQL 21577 Dmitry Narizhnykh 02/24/2009 04:03AM


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.