Save Microsoft Query Query and database password in Excel

Source: Internet
Author: User

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:

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.