Problem with loading Access data in 64 bit.

[rbartlejr]

I have an Access database that is 64 bit. I had 32 bit Office on my computer and uninstalled 32 bit and installed 64 bit Office. I still get this error message:

Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read 'XY_Create.mdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."

I tried loading the client software anyway and it still won't load. Anyone else have this issue?

[v-yingjl · Accepted solution]

Hi @rbartlejr ,

From the error message, the ACE OLEDB provider is required to connect Access database so that it can fetch data from Access. So, please download Microsoft Access Database Engine 2010 Redistributable on your machine and try it again:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

You can also refer the following similar case that could help you:

https://community.powerbi.com/t5/Desktop/How-to-Resolve-this/td-p/145205

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.