locked
Finding error when i tried to transfer data of sql query in excel sheet RRS feed

  • Question

  • i have written code-

       insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=D:\testing.xls;',
    'SELECT * FROM [SheetName$]') select username,paid_date,payment,payment_detail from [znetacc].[znetuser].[receipt_table1]


    And finding error-

    Msg 7399, Level 16, State 1, Line 1
    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
    Monday, December 21, 2009 1:21 PM

Answers

All replies