What is a DQY file? A DQY file is a database query used by Microsoft Excel, a popular spreadsheet application. It stores a query defined with Microsoft Query or the Query Wizard included with Excel that accesses an external database to retrieve data and import it into an Excel spreadsheet. DQY files are saved in the ODBC standard for compatibility with other databases.

More Information Most Excel users will not create or open DQY files. However, advanced users looking to import data from a database may create and open DQY files since they are useful for saving queries to be used again. To create a DQY file with Query Wizard or Microsoft Query in Excel 365, follow these steps: Select Get Data in the Data tab Choose From Other Sources → From Microsoft Query Verify that the "Use the Query Wizard to create/edit queries" checkbox is checked in the "Choose Data Source" dialog Select the data source, click OK , choose the database you want to query, and define the query DQY files created with the Query Wizard or Microsoft Query in Excel 365 are saved in the following location, by default: C:\​Users\​[username]\​AppData\​Roaming\​Microsoft\​Queries NOTE: DQY files are primarily used by Excel 2007 to 365 users.