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
farsoftcorpAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
Try the Ace engine instead of Jet

For example

See the syntax from here

http://www.connectionstrings.com/excel-2007

Sid
0
 
SiddharthRoutCommented:
Just did a quick search and found this... I guess it is a similar query as yours.

Title: Openrowset for Excel
http://social.msdn.microsoft.com/Forums/en/transactsql/thread/1ed0751c-2014-4b02-b118-73f318d7da87

Sid
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.