Re: Insert data from excel files to database table
Posted by:
yilinglim
Date: July 21, 2004 03:33AM
ya.. LOAD DATA LOCAL INFILE is work!!
so fantastic.. without editing anything and just save under .csv ..
everything get done!!!
may i know what ".csv" stand for ?? this .csv is so great, which company developed it ? and i think that this .csv is especially design for LOAD DATA ..
why excel spreadsheet cant be used in LOAD DATA ??
i tried to load the data in .xls format.. shown warning and have error in the database table.
Thanks a lot for helping me !!!
P/S i'm new to mySQL.. so, don't be surprise about my curiousity on these ''stupid'' questions =)
Subject
Views
Written By
Posted
35257
July 20, 2004 11:41PM
21651
July 21, 2004 12:35AM
11879
July 21, 2004 01:45AM
19347
July 21, 2004 02:54AM
Re: Insert data from excel files to database table
12029
July 21, 2004 03:33AM
9273
July 21, 2004 04:54AM
7763
May 02, 2008 01:36AM
9834
December 09, 2005 07:52AM
5285
March 25, 2009 10:54PM
6436
June 22, 2006 07:29PM
6454
January 30, 2006 07:51AM
5408
November 08, 2008 02:28AM
5416
January 22, 2009 12:19PM
6134
February 24, 2009 03:23AM
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.