Forum Discussion

darrylwilson's avatar
darrylwilson
New Member
10 years ago

import multiple access queries from network locationns

Hi   The company i work for have (for each user) an Access database application that is stored on their desktops (which is stored in a cluster storage location).   How can I import the queries fr...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi All,

 

I have been trying to import Access database into Power BI and have been unsesscceful with the import.  I keep getting the error message " Unable to Connet'' we encountered an error wist trying to connect.

 

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 Engin 2010 Access Databes Engine OLEDB provider may be required to read 'Mecologix Access Live - Source - HK.accdb'. To download the client software, visit the following site:

https://go.microsoft.com/fwlink/?LinkID-285987."

 

I have downgraded from 64bit to 32bit but still having the same error message pop-up.

 

Can you advise me what to do moving forward?