BCP Error

Hi,
I'm getting the following error when I use BCP to import a tab
seperated file exported from Excel.
I hope someone can help me figure it out.
I'm using the following command:
c:\>bcp myComm.dbo.cmrc_products in test2.txt -n -T -Sbiff\sqlexpress
SQLState = 22001, NativeError = 0
Error = [Microsoft][SQL Native Client]String data, right truncation
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP
data-fil
e
I think it has something to do with the column widths and datatypes of
the import, but I don't know. I've been staring at a command line for
so long, I can't see straight.
Thanks for the help.
Tom
i figured this one out myself after many cups of coffee...
Basically my datafile was FUBAR and I wasn't using the -c switch...
bcp is VERY touchy and gives no breaks at all. Attention to detail is
the order of the day when using this little proggie.
|||i figured this one out myself after many cups of coffee...
Basically my datafile was FUBAR and I wasn't using the -c switch...
bcp is VERY touchy and gives no breaks at all. Attention to detail is
the order of the day when using this little proggie.