MySQL Forums
Forum List  »  Other Migration

Re: import from Excel to MySQL
Posted by: Davorin Jelen
Date: September 20, 2004 07:19AM

Simply export data from excel as TXT or CSV. Than use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;





Options: ReplyQuote


Subject
Views
Written By
Posted
301689
September 10, 2004 04:53AM
Re: import from Excel to MySQL
171494
September 20, 2004 07:19AM
66213
August 18, 2005 12:00AM
60051
September 05, 2005 10:45PM
32921
April 15, 2008 04:14AM
47506
September 26, 2004 02:30PM
34597
February 01, 2005 06:05AM
25911
January 25, 2006 07:49AM
26369
June 19, 2006 09:02PM
23062
April 11, 2007 07:52PM
11823
September 10, 2008 08:32AM
16616
July 07, 2007 08:11AM
18274
October 08, 2007 10:11AM
14309
November 04, 2007 12:36PM
11915
February 26, 2008 03:43PM
15177
February 26, 2008 03:49PM
11495
February 27, 2008 05:32PM
11781
March 19, 2008 03:49AM
12249
March 24, 2008 05:58PM
7868
March 14, 2009 07:55AM
13735
May 18, 2008 08:55AM
11116
March 07, 2009 11:33PM
14171
July 07, 2008 12:17AM
23037
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.