G'day Colin > load data local infile '~/Documents/web export.txt' into table stories > fields terminated by ',' enclosed by '"' escaped by '\\' lines > terminated by '\r' > (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication); €€€€ Thanks for your suggestion but sadly it didn't fix the problem - I get exactly the same result.
> Also, if this is a windows text file you should be using \r\n not \r, > if this is a unix text file you should simply use \n. €€€€ It's actually coming from a Mac (OS9) system and it exports using just /r as the record delimiter. Cheers and thanks again Kim sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php