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(https://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

 

Answered By 590495 points N/A #304356

Installing the 2010 Office System Driver Data Connectivity Component error

qa-featured

Though I haven’t seen it happen yet but it is possible that the Microsoft Office Excel shortcut you clicked on your desktop is linked to the Office Excel application that is actually located on a different computer on your local area network. If this is the case, Office Excel will really not run because the application has to be installed on your computer.

If your workstation has Microsoft Office installed, I guess you need to remove the Microsoft Office Excel application and then install it back. To remove the Office Excel feature, click “Start,” “Control Panel,” and then “Add or Remove Programs.” Select your version of Microsoft Office then click “Change.” On the next screen, make sure “Add or Remove Features” is selected then click “Continue.”

On the next screen, select “Microsoft Office Excel” then set the option next to it to “Not Available” then click “Continue.” Follow the instructions.

Remove Office Excel from Microsoft Office

Once Office Excel is removed, open your web browser and download the free version of CCleaner and install it. Once installed, start CCleaner and clean your system. Restart your computer then repeat the same steps to access the installation options of Microsoft Office. Install Microsoft Office Excel back by setting its option to “Run from My Computer” or “Run all from My Computer.”

Click “Continue” and follow the instructions. See if this works. If you want to convert CCleaner to Pro, download the codes and follow the instructions.

Related Questions