Solved

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

Posted on 2011-09-29
4
4,676 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

738 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