error while exporting data from sql server to excel RRS feed

  • Question

  • Hi,
    I am trying to export data from sql server to excel.

    The query that I used is s follows
    INSERT INTO OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Folder1\abc.xls','select * from [Sheet1$A1:IV65000]')
    column1,column2.... from Table1

    I get the following error message while doing so..
    String or binary data would be truncated.
    The statement has been terminated.

    One of the column's holds data more than 225 characters.
    What is the way to correct this, i want the whole data of the colum in the excel sheet.

    Saturday, July 26, 2014 4:00 PM


All replies