Solved

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

Posted on 2011-09-29
4
4,503 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 69

Expert Comment

by:Éric Moreau
Comment Utility
0
 
LVL 25

Accepted Solution

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

Expert Comment

by:Éric Moreau
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now