Power Query: getting DataFormat.Error message when loading to data model

Hi - I just installed the 64bit Excel 2016 and used power query to query data from access database (mdb file). When I try to load it into the data model, I get a "download failed" with the following message "[DataFormat.Error] Unspecified error"

I am guessing this is some non-compatibility issue between 64bit Excel 2016 and mdb files. Desperately looking for a fix. Any help would be appreciated.

 

Question Info


Last updated July 4, 2019 Views 1,165 Applies to:
Answer
Answer
Solved. Turns out I needed to uninstall the 32bit Access Database Engine 2010 and install the 64bit version.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.