MySQL Forums
Forum List  »  Other Migration

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 =)



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.