Installing the 2010 Office System Driver Data Connectivity Component error

Asked By 20 points N/A Posted on -
qa-featured

Hi

I have a 64 bit machine which results in an error when I try to open MS Excel.

The screenshot of the error is attached below:

 

 

The message states:

Failed to read Excel source data: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

Install the 2010 Office System Driver Data Connectivity Component:http://www.microsoft.com/en-us/download/details.aspx?id=13255

Or install the 2007 Office System Driver Data Connectivity Componenet:http://www.microsoft.com/en-us/download/details.aspx?id=23734

I did all the above mentioned steps in the error message but still the same problem persists.

Any help in this regard will be highly appreciated.

Thanks a lot

Regards

SHARE
Best Answer by Maverick Aabel
Answered By 0 points N/A #192852

Installing the 2010 Office System Driver Data Connectivity Component error

qa-featured

Hello Jhon,

Thanks for sharing your with us, you can solve this problem very easily just follow the following steps:

1. Download and install the .exe file from here: 

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

2. In VS click add the data source, follow the wizard.

If you are still unable to solve your problem then visit

Thanks.

Best Answer
Best Answer
Answered By 0 points N/A #192853

Installing the 2010 Office System Driver Data Connectivity Component error

qa-featured

Hi Jhon,

In order to fix this problem we will try for the two solutions:

First Solution:

We need to check manually that the DLL responsible of this driver is registered.

1. First go to Start => type CMD in Run window (you will see that CMD will appear)

2. Right click on CMD and select "Run as administrator"

3. Now, within the CMD, navigate to C:WindowsSysWOW64 folder

4. Here type regsvr32(http://technet.microsoft.com/en-us/library/bb490985.aspx) followed by dll file (odbcconf.dll) (ex: regsvr32 odbcconf.dll)

5.   You should receive a message that the DLL was successfully loaded.

Second approach:

You must download and install a Microsoft pack (Microsoft Office Access Runtime and Data Connectivity  Service Pack 3 or SP3)

1.   First download from the Official Microsoft site: http://www.microsoft.com/en-us/download/details.aspx?id=27835 the package.

2.   Please quit any other programs that are running

3.   And run the executable (it has ~72. 5 MB in size)

I hope this will help you,

Aabel

 

Login/Register to Answer

Related Questions