Using LOAD DATA INFILE Import Method

[James Choi]

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