Data for Source Column 3('Col3') is too large for the specified buffer size.





    I have a problem to import xls file to sql table, using MS SQL 2000 server.

    Actual main problem associated with it is xls file contain one colum having large amount of text which length is approximate 1500 characters.

    I am trying to resolve it through like save xls to csv or text file then import but it also can not copy whole text of that column, like any column in xls having 995 characters then text or csv file contain 560 characater. So, it is also wrong.


    thanks in advance, if any try to resolve

    Friday, August 24, 2007 11:56 AM

All replies




    if you are using dts then find the longest row and either put that row up the top to be in the first 8 rows or add a row in the first 8 rows and put a string in that is at least as long as you need it to be as dts checks the first 8 rows to work out widths.




    Wednesday, January 09, 2008 12:05 PM