I want to transfer data from a table in sql server to mysql. I use C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to write the data to a text file and then use load data infile ‘/var/www/html/tblname.txt' into table tblname;
It works fine for all the tables except this one table which has description field with several lines. It assumes each line as a seperate field rather then one field and so create errors. Please help. Regards Harpreet _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --------------------------------------------------------------------- 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