Re: Insert data from excel files to database table
Great stuff - glad it worked OK.
csv stands for 'comma separated values' and is just a simple text file format. It hasn't been developed by anyone. A native Excel .xls file isn't compatible with LOAD DATA INFILE because it is in binary format.
It's worth reading the on-line MySQL reference manual for more information.
Nick
PS - It is better to ask a 'stupid' question than to never know the answer...
--
Nick Roper
Subject
Views
Written By
Posted
35783
July 20, 2004 11:41PM
21987
July 21, 2004 12:35AM
12089
July 21, 2004 01:45AM
19560
July 21, 2004 02:54AM
12397
July 21, 2004 03:33AM
Re: Insert data from excel files to database table
9459
July 21, 2004 04:54AM
7979
May 02, 2008 01:36AM
10002
December 09, 2005 07:52AM
5524
March 25, 2009 10:54PM
6608
June 22, 2006 07:29PM
6635
January 30, 2006 07:51AM
5582
November 08, 2008 02:28AM
5622
January 22, 2009 12:19PM
6475
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.