Forum Discussion
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...
I tried this but I still got error. First time It look like it is working but after that I got errors.
No idea if the following option exists in Excel 2016:
If it does, refer to my 1st reply (to pottyponder) on this discussion
I can't find the option in Excel 2016. In excel 2019 I tried this but it keeps asking for password.
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- Thank you. Do you by any chance have an idea on how to store the password for the legacy connector?