Import Excel file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import Excel file

I am trying to import an excel file into my DB but i am getting the follwing error..
quote:Data 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:
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.