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

Reply via email to