Issues with Microsoft.Jet.OLEDB.4.0 provider RRS feed

  • Question

  • Hi,

    When I am trying to execute the below query on Windows7 OS and SQL Server2008 Express edition:

    INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=E:\Test.xls;','Select * from [Sheet1$]')
    SELECT EmpID,EmpName FROM dbo.Emp

    i am getting the below error:

    Msg 7308, Level 16, State 1, Line 1
    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

    Can you help me out how resolev this issue.


    Tuesday, December 7, 2010 5:31 AM


All replies