Bulk Insert

[sparkme]

I was trying to Insert into a table from a text file


bulk insert dbo.Client from 'C:\Client.text'
with (
datafiletype = 'native' )

I'am getting the following error:


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.

Can some one help me,Thanks in advance.

 

[JamesLean]

What's the format of your data file?

--James

 

[sparkme]

Hi James,
Its in Tab delimted format.I created the file from Query analyzer by saving the result of the query into a file called client.txt with tab delimited option.

 

[sparkme]

Now its Working,

When i run only this statement
bulk insert dbo.Client from 'C:\Client.text'

Anyhow thanks James