farsoftcorp
asked on
Excel connection string in sqlserver 2008 R2
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.
error1.jpg
error1.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Title: Openrowset for Excel
http://social.msdn.microsoft.com/Forums/en/transactsql/thread/1ed0751c-2014-4b02-b118-73f318d7da87
Sid