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.

Solved. Turns out I needed to uninstall the 32bit Access Database Engine 2010 and install the 64bit version.

1 person was helped by this reply


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.


Question Info

Last updated October 22, 2020 Views 2,483 Applies to: