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 September 25, 2019 Views 1,378 Applies to:
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.