MySQL Forums
Forum List  »  Other Migration

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
300054
September 10, 2004 04:53AM
169472
September 20, 2004 07:19AM
65372
August 18, 2005 12:00AM
59280
September 05, 2005 10:45PM
32396
April 15, 2008 04:14AM
46723
September 26, 2004 02:30PM
33816
February 01, 2005 06:05AM
25275
January 25, 2006 07:49AM
25515
June 19, 2006 09:02PM
22402
April 11, 2007 07:52PM
11287
September 10, 2008 08:32AM
15820
July 07, 2007 08:11AM
17644
October 08, 2007 10:11AM
13776
November 04, 2007 12:36PM
11437
February 26, 2008 03:43PM
14579
February 26, 2008 03:49PM
10980
February 27, 2008 05:32PM
11273
March 19, 2008 03:49AM
11647
March 24, 2008 05:58PM
7402
March 14, 2009 07:55AM
13192
May 18, 2008 08:55AM
Re: import from Excel to MySQL
10485
March 07, 2009 11:33PM
13644
July 07, 2008 12:17AM
22360
February 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.