Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machineAsk Questions

 Posted on 12/11/2018

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.

Thank you

Share On: facebook gplus twitter
profile
Asked by Narendra Shah on 12/11/2018 Score: 91 points
Add Comment:

Comments

1 Answers

1 Corrected Answers
Aproved Answers
1
Profile
Answered by Haresh Chaudhari on 12/12/2018 10:35:55 AM Score: 305 points

Hi

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.

Comments

Hi, thanks for your response. I changed that to x64 and its working fine for me. Thanks for your response, it really helped me.
12/12/2018   17:43:03   Narendra Shah
Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
...or Join us
Download, Vote, Comment, Publish.
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.