MySQL Forums
Forum List  »  Other Migration

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

You can save an excel worksheet as a csv file and then use the LOAD DATA INFILE command to load it into a table and specify how fields & rows are terminated and how special characters are escaped.

See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html



--
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.