MySQL Forums
Forum List  »  Microsoft Access

Re: Using LOAD DATA INFILE Import Method
Posted by: Mike Hillyer
Date: October 28, 2004 09:08AM

Try

LOAD DATA LOCAL INFILE "c:\temp\tblacn.txt"
INTO TABLE tblACN
FIELDS TERMINATED BY ','
ENCLOSED BY '"';

Omit the column names since your tables only has the two columns. You may want to add a line terminator clause if that does not work.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine

Options: ReplyQuote


Subject
Views
Written By
Posted
4648
October 27, 2004 02:30PM
Re: Using LOAD DATA INFILE Import Method
2096
October 28, 2004 09:08AM


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.