Solved

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

Posted on 2011-09-29
4
4,649 Views
Last Modified: 2012-05-12
I am trying to export data from a SQL 2008 database to an Excel spread sheet.  Unfortunalty I am running into an error that I never seen before, here is the error.


TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

------------------------------
BUTTONS:

OK
------------------------------


I am not sure why this is happening any ideas?
0
Comment
Question by:RayManAaa
  • 2
  • 2
4 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 36814272
0
 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
ID: 36815073
The component is not installed in the server. The link emoreau should help you with this.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 37481887
why is TempDBA comments is accepted when it is just an acknowledge to install the components I linked you to?
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 37481936
RaymanAaa,
         I second Expert emoreau's thought. Can you please request to open the question and give points to the expert? I don't deserve the point you awarded.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

680 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