Hi Stanley, > I am trying to upload a CSV file directly to the database using command > > strSQL = "load data infile '" & strFNPath & "' into table products" > where , strFNPath =>Path of the file > > But its not working correctly ,it uploads some data and then seem to stop > or enter values in the wrong places. > > Any help will be appreciated.
Well done, you've successfully negotiated half of the 'traps' inherent in using LOAD DATA! I'll take a flying leap into the void and suggest that you are using Windows! Windows terminates lines in text files with CR and LF characters. Unix however uses only LF (and Mac only CR - but that's another story). Check out 6.4.9 LOAD DATA INFILE Syntax and alter the MySQL default terminators/delimiters to suit the source file format. Regards, =dn --------------------------------------------------------------------- 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
