bcp error
when I insert into a table from a xls file, and a error was appeared:
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver] string data,right truncation
and my code:
exec master..xp_cmdshell'bcp bluepages..Liu in e:\dd.xls -c -Usa -P000000'
I do not know where is the wrong.
who can help me ? And send the answer or key to my email(shtjasows@sohu.com)
thanks!!
Subject
Written By
Posted
bcp error
February 20, 2005 08:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.