Forum Discussion
pottyponder
Jul 06, 2022Copper Contributor
Unable to Import data from password protected Microsoft Access Database
Hi, I am trying to import data into excel from my Access database that is password protected. It worked fine with Excel 2016 and asked me to enter a password when it connects but now I have upgraded...
arthurloibin
Sep 26, 2022Copper Contributor
I can't find the option in Excel 2016. In excel 2019 I tried this but it keeps asking for password.
Lorenzo
Sep 26, 2022Silver Contributor
I don't have Excel 2016 nor 2019 so can't check how this works with those versions. However...
If Excel 2016 doesn't expose a "From Access (Legacy)" option I guess it's because that version uses this old/legacy connector by default (just a guess, not sure)
Re. "I tried this but it keeps asking for password". If you talk about the following dialog box:
It's expected as the password (for such Legacy connector) is not stored in the Data Source Settings
- arthurloibinSep 26, 2022Copper ContributorThank you. Do you by any chance have an idea on how to store the password for the legacy connector?
- LorenzoSep 28, 2022Silver ContributorAs Far As I Know this isn't possible