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...
Hi pottyponder / Paul
Am a bit suprised this worked with 2016. Anyway...
Power Query/Get & Transform standard connectors (Excel file, Access DB...) don't support password protected files, hence the error you get
Within Excel:
- File > More... > Options
- Data > Show legacy data import wizards > Check option From Access (Legacy) > OK
Then to import from Access, do not choose Data (tab) > Get Data > From Database > From Microsoft Access Database. Instead:
- Data (tab) > Get Data > Legacy Wizards > From Access (Legacy)
I have the same problem. Is this means that I cannot import the data from password protected access into excel? I have access 2016.