I am running the following query in sql server 2008 r2(64-bit),
MS office 2007 excel file.
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [Sheet1$]')
its showing 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.
i run the following code
sp_configure 'show advanced options', 1;
sp_configure 'Ad Hoc Distributed Queries', 1;
but still its showing the same error...
thanks and regards