MySQL Forums
Forum List  »  Microsoft Access

Using LOAD DATA INFILE Import Method
Posted by: James Choi
Date: October 27, 2004 02:30PM

Can someone tell me why the text file is NOT importing correctly?

Table Name in mySQL is: tblACN
Columns in mySQL are: txtACN and txtDate (Both are DataType CHAR)

The command syntex used:
-> LOAD DATA LOCAL INFILE "C:/temp/tblACN.txt"
-> INTO TABLE tblACN
-> FIELDS
-> TERMINATED BY ','
-> ENCLOSED BY '"'
-> (txtACN, txtDate);

File is import but when I check the table the values imported are:
0001 and "04102

Actual values imported should be:
0001 and 041025

Values in the Text File name tblACN.txt are:
"0001","041025"

Any Help will be greatly appreciated

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Using LOAD DATA INFILE Import Method
4669
October 27, 2004 02:30PM


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.