MySQL Forums
Forum List  »  Other Migration

Re: Insert data from excel files to database table
Posted by: Nick Roper
Date: July 21, 2004 04:54AM

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

Options: ReplyQuote




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.