"Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine" but I have it installed already

asp.net oledb oledbconnection oledbexception
Raul Miranda picture Raul Miranda · Mar 2, 2019 · Viewed 9.4k times · Source

I have the same problem as others but (in this case) I have already installed that component.

UPDATE: I have Windows 10 x64, Office 2016 x64, MS Access Database Engine 2016 x64. Is a ASP.NET .NET Framework 4.5 target AnyCPU Visual Studio Solution (Web Site project).

The image is just for demonstrate that I have installed this OLEDB provider.

Provider is registered!

My code is:

"Provider=Microsoft.ACE.OLEDB.16.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR={1}'"
cmdExcel.Connection = connExcel
connExcel.Open()

The last line break and cause the Exception.

Answer

Related questions

The Microsoft Jet database engine could not find the object 'Sheet1$'

I'm attempting to read a spreadsheet file called Book1.xls which contains a worksheet called Sheet1 However I'm getting the following error: The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and …

Read More
System.Data.OleDb.OleDbException: Could not find installable ISAM

I have scoured the net, and found many people asking this, yet none have fixed my answer. I have a Connection Class, and a Method that uses that Class in a page. DataConn.cs public static OleDbConnection ConnectExcel() { //Store the …

Read More
How to check if a client has SQLNCLI10 provider installed when browsing?

I have a c# website that allows a client to connect directly to a remote SQL Server database from their PC, bypassing the web server, by using a 3rd party ActiveX control. I was originally using the SQLOLEDB provider and …

Read More