Re: Data truncated while loading

[Xavier Manach]

Hi

Did you try with ENCLOSED BY '"'
and

and this format :
3 | 194 | 1 | "Need Quote" | "per Rich's specifications in phone msg of 9/20/2001. Lump at 23, in between payments and retirment payments, 3 options using $240,000 per child" | 2001-09-25 00:00:00.0 | "N/A" | "Yes" | null | null | 1 | "Normal" | null

ESCAPED BY can help you if you have " in your texts.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Good Luck.