i try to import file to database table but i get the error like this:

Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

below is the code i use:

C:\New Folder>bcp abc..NewCustomer in C:\test.cm -fc:\format.fmt -SEPPWKS01\SQLEXPRESS -Usa -Padmin

can anyone help me....
plz......

Thanks!

Can you post your FMT descrition also the table structure here? FMT is very sensitive, even a minor mistake there will never let us successfully export/import data using bcp.

Sometimes it could be something wrong with the data file too, which contradicts with your FMT description. So you got to look at all possibilities.

With less info posted, except the error, I can't point out where you go wrong.

_________________________
- Vijay G
Strive for Perfection