I'm 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 have no clue how to fix this. My operating system is Windows 7.
This error indicates that the Microsoft Access Database Engine 2016 is not installed, download and install the Microsoft Access Database Engine from this link should fix this problem.
Right-click on the file, nzoledb. dll, and select Properties. The version number is displayed either in the Product Version field on the Details tab or under the Version tab, depending on your OS.
Well, you need to install it. You're looking for:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With