Loading data problem

[subhavs]

Hello everyone,

I am very new to MySQL and just started to play arounnd with it.

I have created a table with 4 fields and I am trying to populate this table with data from a flat file. The flat file has exactly 4 fields and they are separated by commas.

I am using the load data command as follows -
load data
local infile 'acdata.txt' replace
into table ACLookUp
fields terminated by ','
(Field1, Field2, Field3, Field4);
The data is not going in right. Two records from the file are getting loaded as one record in the table and the data is all jumbled up.

Am I doing something wrong ? Please help.

Thanks in advance.

- Subha
Nothing is impossible, even the word impossible says I'm possible.