Hi Folks,

I'm trying to import data from a windows text file into a mysql table via phpMyadmin. The text file is comma delimited, as my exmaple below

column1, column2, column3, column4, column5
data, data, data, data, data
data, data, data, data, data
data, data, data, data, data
data, data, data, data, data
data, data, data, data, data
and so on....

Basically, i've told phpmyadmin to use "," as the field terminator, but when I try and import the contents of the file, it only imports the column headers and the first line of data.....phpmyadmin also knows about "\r" and "\n" in the "Lines Terminated" field.

Does anyone have any ideas why this is happening?

Cheers

Dave

P.S Please feel free to shout if this belongs elsewhere! :-)