Make sure your format file has another line feed after the last lineTest CodeSET NOCOUNT ONCREATE TABLE myTable99(Test char(12), Test2 char(9), Test3 char(8))GOBULK INSERT Northwind.dbo.myTable99 FROM 'd:\tax\Test.dat' WITH ( FORMATFILE = 'D:\tax\test.fmt' )GOSELECT * FROM myTable99GOSET NOCOUNT ONDROP TABLE myTable99GO
Format File8.031 SQLCHAR 0 12 "" 1 Test SQL_Latin1_General_CP1_CI_AS2 SQLCHAR 0 9 "" 2 Test1 SQL_Latin1_General_CP1_CI_AS3 SQLCHAR 0 8 "\r\n" 3 Test2 SQL_Latin1_General_CP1_CI_AS
Sample Data12345678901234567890123456789XXXXXXXXXXXXYYYYYYYYYZZZZZZZZ
Brett8-)