Post reply

Issue in OPENROWSET

  • February 13, 2012 at 7:50 am

    #250622

    Hi,

    I have installed SQL Server2008R2 and office2003 on a Windows7 machine. While I am trying to execute OPENROWSET with the following query

    SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Tools\ExcelFileName.xls;HDR=Yes', [Results$])

    it is showing "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." error.

    Can somebody help me to resolve this issue?

    Thanks & Regards,

    Kumar Anand

  • February 13, 2012 at 10:00 pm

    #1446628

    Perhaps, you can try to find an appropriate download for 64bits Jet. I ran into similar problem using 2008R2 against earlier office, decided not to fight that battle - upgraded to office 2010 Ace - data interop is working great.

    Useful link: http://stackoverflow.com/questions/2899201/microsoft-ace-oledb-12-0-64x-sql-server-and-86x-office

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply