Thanks for the help. The problem was the line terminating character. My source files are in DOS format '\r\n' and not the default posix one '\n'.
Thanks again. > If it's an option, I would run your datafile through a processor > (sed on unix, ultraedit on windows) to search and replace the string > "" > with > \" > > > and try it with > fields terminated by ',' optionally enclosed by '"' as mentioned by > Mike Johnson's posting > > (escaped by '\' is default) > > >> -----Original Message----- >> From: Daniel Kiss [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, December 09, 2003 3:02 PM >> To: [EMAIL PROTECTED] >> Subject: LOAD DATA LOCAL INFILE >> >> >> Hi all, >> >> >> How should I set the parameters of the LOAD DATA LOCAL INFILE >> command for a comma separated text file like this: >> >> "Text field",.4,123 >> "Text field with "" included quote",,45 >> "Text field with "","" a comma between quotes",1.2,44 >> >> >> Thanks, >> Dan >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]