none
error while exporting data from sql server to excel

    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]')
    select 
    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

Answers

All replies