Microsoft ACE OLEDB 12 0 provider is not registered on the local machine

Question

I have been trying to get data from an Excel file on a button click event. My connection string is:

string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;";

When I click on the button, I got the following error:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I am unable to fix this. My operating system is Windows 7. Any leads would be helpful.

Answer 1

In order to fix this problem, you will need to install the system driver of windows. Have shared the link for direct download below:

•  2007 Office System Driver: Data Connectivity Components.