Solved

Excel connection string in sqlserver 2008 R2

Posted on 2011-03-25
4
537 Views
Last Modified: 2012-05-11
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
Comment
Question by:farsoftcorp
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35214148
Try the Ace engine instead of Jet

For example

See the syntax from here

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

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35214191
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
 
LVL 24

Expert Comment

by:broomee9
ID: 35821695
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question