[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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