Hi Glenn,
You're using slash '/' instead of backslash. Also new line is usually \r\n. Try
8.0
2
1 SQLCHAR 0 18 "\t" 1 sku1 SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 4 0 "\r\n" 2 biblio SQL_Latin1_General_CP1_CI_AS
>This is my first attempt at using either BCP or Batch Insert. Can someone point me in the right direction?
>
>My text file looks like this
>xxxxxxxxxx/t:xxx...xxx/n: (yes tab and newline not literal /t:)
>
>my SQL table looks like
>sku1 char 18 not null
>biblio Text not null
>fname Char 25 not null
>UID int identity not null
>
>my format file looks like:
>8.0
>2
>1 SQLCHAR 0 18 "/t:" 1 sku1 SQL_Latin1_General_CP1_CI_AS
>2 SQLCHAR 4 0 "/t:/n:" 2 biblio SQL_Latin1_General_CP1_CI_AS
>
>my command looks like:
>bulk insert dbo.Annotation from 'd:\TEMP\annotations.txt'
>WITH (
> DATAFILETYPE = 'char',
> fORMATFILE = 'D:\TEMP\ANNOTATIONS.FMT'
> )
>
>my error looks like:
>Server: Msg 4866, Level 17, State 66, Line 1
>Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
>The statement has been terminated.
--sb--