2

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.

Raul Miranda
  • 71
  • 1
  • 3
  • 10
  • 1
    See here: https://stackoverflow.com/questions/17716207/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine-w/17716238#17716238 – Steve Mar 02 '19 at 19:22
  • x64, x64 ACE install – Raul Miranda Mar 02 '19 at 19:22
  • 1
    .Net is not SQL Code. You .Net code might be running a different bitness to your SQL Server (i.e. x86 instead of x64). Or your code might not even be running on the same SQL Server – Nick.Mc Mar 03 '19 at 02:30
  • The image is just to demonstrate that I have installed the provider that Visual Studio says I don't have. – Raul Miranda Mar 04 '19 at 15:05

0 Answers0