I have an application in C# where I am trying to read Excel data. When my application try to open connection, it throw me error like "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"
I tried to install microsoft access database engine but it doesnt worked for me. I am using Office 365 with 2016 version. Appreciated any help for this issue.
2 Answers1 Corrected Answers
First, you may install 2007 Office System Driver: Data Connectivity Components. from here -> https://www.microsoft.com/en-us/download/details.aspx?id=23734
Then after restarting your machine, you can change your target AnyCPU to x86 or x64 and try it. I was having same issue with Office 365 with 2016, I changed target build option to 86 and it was working perfect.
To change that go to properties by right click on project in solution explorer section -> Build -> Platform Target (Here choose x86 or x64)
I hope that help you to fix your problem.