Forum Discussion

Copper Contributor

Apr 24, 2017

Excel get External Data in Access

I need to get external data into Excel from a password protected Access database (of which I know the password) which I would like to run Pivots or Power Pivots from. When I go to "Get External Data"...

BI & Data Analytics

Excel Desktop

SergeiBaklan

Diamond Contributor

Apr 24, 2017

Hi Matt,

For my knowledge connection to password protected Access database is not supported by G&T. This link is from Power BI, but they use the same with Excel engine

http://community.powerbi.com/t5/Desktop/How-do-I-connect-to-a-password-protected-Access-Database-Is-this/m-p/143447#M61889