[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

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
0
farsoftcorp
Asked:
farsoftcorp
  • 2
1 Solution
 
SiddharthRoutCommented:
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now