Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 error on importing

Author  Topic 

a.ashabi
Posting Yak Master

117 Posts

Posted - 2009-09-16 : 17:43:53
Hi.I've tried to import an Excel file with large values.
It gave me the error:
Error at source for row number 2731.
data for source column is too large for the specified buffer size.

I changed the data type of that field to varchar(8000)
but still got the same error.
plz help me & let me know how should I import the huge xls files.
thanks

a.ashabi
Posting Yak Master

117 Posts

Posted - 2009-09-16 : 17:57:36
thank u I found the solution on the web site :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22637

it let me import the file but
now the problem is except that 8 fields which I gave them the fake values the rest are null.
:(
Go to Top of Page
   

- Advertisement -