* Barbara Ferrell > only every other line imported correctly and there was a quote around the
Seems like there is a line ending problem... windows use CRLF as line endings in text files, but mysql expects LF only... have you tried "LINES TERMINATED BY '\r\n';" CR = ascii 13 = \r = return (carrige return) LF = ascii 10 = \n = new line (line feed) -- Roger 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
