Importing data in MySQL: troubles with "data&

[Anon]

I've imported 3000 records in a MySQL table using the command LOAD DATA using a txt file.
All fields are correctly imported, the only that gives me troubles is where there is a data in the format YYYYMMGG.
All records are set to 00000000 and only the last record have the right data as in the original txt file.

What could be wrong !?

Have you got any idea about?

Thank you

Fabio

[Anon]

what data type is this field trying to be inserted into? (looks like a date? )

if the database table field is an INT type it should insert OK. A char(8) would work if the data in the CSV file has quotes around it?

[Anon]

Thank you for your answer,

Records are like this, from a plain ASCII txt file, one record for each line that ends with a newline:

#1001# #HOT SHOTS# #ABRAHAMS# #JIM# #SHEEN# #CHARLIE# #ELWES# #CARY# #1991# #80# #Commedia# #19931015#

The last field is the date, fields are enclosed between # and divided by Tabs.
All fields are right imported correctly, except the date...

I've used the following command in MySQL:

load data infile 'test.txt' into table tablename fields terminated by '\t' enclosed by '#';

Have you got suggestions about my trouble ?