bulk copy - error

[piti]

i'm trying to insert data from a text file using the bcp utility
this is my command:
bcp MyDatabase.dbo.MyTbl in c:\Mssql7\files\inputdata.txt -T -fc:\Mssql7\files\bcp.fmt -ec:\Mssql7\files\inputlog.err

and i'm receiving this error:
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL ServerDriver]Unexpected EOF encountered in BCP data-file

0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 17916

any idea what's wrong?

 

[tlbroadbent]

How have you defined the row terminator in the format file? It may not match the actual row terminator. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[piti]

so here's my bcp.fmt file:

7.0
9
1 SQLCHAR 0 255 " " 1 Col1
2 SQLCHAR 0 4000 " " 2 Col2
3 SQLCHAR 0 4000 " [" 3 Col3
4 SQLCHAR 0 4000 "] \"" 4 Col4
5 SQLCHAR 0 4000 "\" " 5 Col5
6 SQLCHAR 0 4000 " " 6 Col6
7 SQLCHAR 0 4000 " \"" 7 Col7
8 SQLCHAR 0 4000 "\" \"" 8 Col8
9 SQLCHAR 0 4000 "\"\n" 9 Col9

both \n and \r\n are not working