Data truncated while loading

[Harirpiya Vedula]

hi,

I have exported tables data from sybse to CSV file. and run the laod command LOAD DATA LOCAL INFILE './path.INTO TABLE table name FIELDS TERMINATED BY '|' ENCLOSED BY '' LINES TERMINATED BY '\r\n'(columns);

for some of the tables it worked fine.but for some tables where column data is more, it came to three lines. so it has taken second line as another record.

for example:

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

i want this to be inserted in one single row.

thanks in advance....