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...
You can try out using OLEDB connection.
Get Data -> From Other Sources -> From OLEDB
Click [Build] button right under the connection string input box. Therefore you will see a [Data Link Properties] dialog box. Select the latest MS Access Provider on [Provider] tab and Input the database path on [Connection] tab. Just put Admin as the user name and check the [Blank Password]. After that click on [All] tab and search for [Jet OLEDB database password] and edit it as you setting. Please take caution that it will expose the database password within the connection string. Random user could obtain the database password by exporting the connection through Power Query or just editing the connection.