Any time. :)

>Thanks again Sergey, you are a life saver!
>
>>
>>The text file doesn't have prefix for text field so it should be 0 in .FMT file. The following works

>>-- .FMT
>>8.0
>>2
>>1	SQLCHAR	0	18	"\t"	1	sku1	SQL_Latin1_General_CP1_CI_AS
>>2	SQLCHAR	0	0	"\r\n"	2	biblio	SQL_Latin1_General_CP1_CI_AS
>>-- .SQL
>>bulk insert dbo.Annotation from 'H:\TMP\bcp\test.txt'
>>WITH (
>>	fORMATFILE = 'H:\TMP\bcp\ANNOTATIONS.FMT'
>>  )