Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 bcp for chinese char

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-15 : 09:09:30
Vivienne Hii writes "I needed to bcp from MSQL Server 2000 to a flat file and also bcp in from a flat file to MSQL Server 2000. I have setup a table called chinese (chinese_name nvarchar(200), english_name varchar(100)). How do I go about doing it?
I assumed is something like
bcp "northwind.dbo.chinese" out c:\chi.txt -c -t
and
bcp "northwind.dbo.chinese" in c:\bmp.fmt -c -t

but this does not work.

Thanks

Vivienne"
   

- Advertisement -