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.
ata for source column 15(‘column’)is too large for the specified buffer size.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.
]]>