SQL Server Performance Forum – Threads Archive
Import Excel file
HiI am trying to import an excel file into my DB but i am getting the follwing error..
quote
ata for source column 15(‘column’)is too large for the specified buffer size.
![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
The error column has text and integers in it,its an nvarchar datatype.
Can any one tell me what is this, wht i need to do to import my excel file. Thanks!
"He laughs best who laughs last"
Follow the referred KBA and I think this is the issue: http://support.microsoft.com/kb/281517/EN-US/
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>