Re: import from Excel to MySQL
Posted by:
Vu Mai
Date: February 26, 2008 03:49PM
1. Export your data from Excel to a flat.csv file.
2. Put that flat.csv in C:\ (just for convenience)
3. Launch mysql command or use MySQL Quer Browser:
LOAD DATA LOCAL INFILE 'C:\\flat.csv' INTO TABLE tblTest FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
(field1, field2)
That should do it !!!
Edited 1 time(s). Last edit at 02/27/2008 05:29PM by Vu Mai.
Subject
Views
Written By
Posted
302844
September 10, 2004 04:53AM
172219
September 20, 2004 07:19AM
66991
October 15, 2004 03:41AM
49991
October 15, 2004 05:07AM
66745
August 18, 2005 12:00AM
60672
September 05, 2005 10:45PM
48110
July 12, 2007 10:17PM
33430
April 15, 2008 04:14AM
47968
September 26, 2004 02:30PM
35069
February 01, 2005 06:05AM
26725
January 25, 2006 07:49AM
26952
June 19, 2006 09:02PM
23544
April 11, 2007 07:52PM
16715
May 17, 2007 11:18AM
12245
September 10, 2008 08:32AM
17020
July 07, 2007 08:11AM
18865
October 08, 2007 10:11AM
14793
November 04, 2007 12:36PM
12401
February 26, 2008 03:43PM
Re: import from Excel to MySQL
15629
February 26, 2008 03:49PM
12488
February 27, 2008 05:32PM
12963
March 19, 2008 03:49AM
12712
March 24, 2008 05:58PM
8301
March 14, 2009 07:55AM
14731
May 18, 2008 08:55AM
11578
March 07, 2009 11:33PM
14667
July 07, 2008 12:17AM
23487
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.