Sorry, my fault, realised the file I was writing for VB was cocking it up.
I was adding chr(13) at the end, but the FileSystemObject write method seemed to be putting the carriage return in too, so MYSQL didn't get the newline character. I changed to use the Print command in VB instead just writing Chr(13) at the end of the line, and it works. Hope that helps somebody else, just took me HOURS to figure it out. Well, I will remember it next time!!! Bye for now -----Original Message----- From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 20:47 To: [EMAIL PROTECTED] Subject: LOAD DATA INFILE Problem Stupid problem this one no doubt. I have a find in mysql\bin called words.txt The file contains tab separated values with a newline character at the end: 225 20 Residence 73.5 63.5 80 187.5 225 20 Planibel 195.5 63.5 79.5 289 When I do LOAD DATA LOCAL INFILE "words.txt" INTO TABLE tblftpagewordpos I get lots of warnings and when I query the table, the values are all zeros (when I have a default value set) I am no doubt doing something stupid, but it is doing my head in now. Any help really appreciated. Many thanks John. --------------------------------------------------------------------- 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
