bcp command:

"C:\PROGRAM FILES\MIcrosoft SQL Server\80\Tools\Binn\bcp" ie_master.dbo.D_BillTypes out Y:\bcptest\D_BillTypes.txt -S******** -Uds_user -P******* -fY:\bcptest\D_BillTypes.fmt

table definition:

USE ie_master

go

CREATE TABLE dbo.D_BillType

(

BTC_BILL_TYPE_CODE char(3) COLLATE...

Unfortunately it is SQL Server 2000.

Just realised i got the right sub post. i.e. newbies, but the wrong thread 2008. :blush:

John