OPENROWSET - Excel 2013 - single-threaded apartment mode

• ites78

  SSC Enthusiast

  Points: 161

  More actions

  May 13, 2014 at 2:27 pm

  #293101

  Hello,

  We updated Excel 2010 To Excel 2013, I received this message based on a query "OPENROWSET"

  Msg 7308, Level 16, State 1, Line 1

  OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used FOR distributed queries because the provider IS configured TO run IN single-threaded apartment mode.

  Example:

  SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\test2.xlsx;HDR=YES;IMEX=1', 'SELECT numFa FROM [Feuil1$]')

  My environment is ;

  Server : Windows server 2008 R2 (64 bits)

  SQL Server Standard Edition 2008 R2 (64 bits)

  Microsoft Office Professional Plus 2013 (32 bits)

  Microsoft Access 2013 Runtime (32 bits)

  Before, it worked with Excel 2010 (32bits) but I had to install Microsoft Access Database Engine 2010 (64 bits).

  Now, with Excel 2013, I can not find an equivalent .... only Microsoft Access 2013 Runtime (32 bits) ....

  I searched on Google but I don't find anything, I find more information about Excel 2010 instead of 2013.

  Could someone help me ?