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.

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

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


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