Save Microsoft Query Query and database password in Excel

Microsoft query definitions can be saved in a file with an extension of qdy, and after you open a Qdy file to read external data, Excel defaults to saving the query definition and data in an Excel file. When you update the data, just refresh the data (click the "Refresh All" button). If there is no "refresh All" button, click on the Menu "Tools"-"Custom", tick "external data" can be selected.

The new query can also copy the currently established query worksheet and click on the menu "Data"-"Import external Data"-"Edit Query" to enter the Microsoft Query editing interface, modify the SQL statement, and produce a new query. A complex query that the wizard cannot establish can also be generated in this way.

Create a query or open a query to read the external data needs to provide the database username and password, enter the password to get data after saving Excel file, the system defaults to save the query definition and data in the Excel file, the next click to Refresh although you can update the data according to the query statement, However, you still need to enter a database password, which allows you to save the database password to simplify the operation and speed up the update. The method is to click on the menu "Data"-"Import external Data"-"Data area Properties", as shown in the following figure:

Check the password to save the following figure: