Home : File Types : DQY File

.DQY File Extension

File TypeMicrosoft Excel Query

DeveloperMicrosoft
Popularity
2.5 (4 Votes)
CategoryDatabase Files
FormatBinary

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:

  1. Select Get Data in the Data tab
  2. Choose From Other Sources → From Microsoft Query
  3. Verify that the "Use the Query Wizard to create/edit queries" checkbox is checked in the "Choose Data Source" dialog
  4. 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.

How do I open a DQY file?

You can open DQY files with Microsoft Excel in Windows and macOS. There are several ways to open a DQY file.

To open the query directly from Excel 365:

  1. Select Get Data in the Data tab
  2. Choose From Other Sources → From Microsoft Query
  3. Click the "Queries" tab in the "Choose Data Source" dialog, select the query, then click Open

To open the query directly from Microsoft Query (included with Excel), select File → Open....

NOTE: You can also select File → Open and choose the DQY file in Excel 365 or double-click a DQY file if it is associated with Excel. These options will run the query and insert the data into a new worksheet.

FREE DOWNLOAD
Open over 400 file formats with File Viewer Plus.

Programs that open DQY files

Windows
Mac
Updated 2/12/2021

About DQY Files

Our goal is to help you understand what a file with a *.dqy suffix is and how to open it.

The Microsoft Excel Query file type, file format description, and Mac and Windows programs listed on this page have been individually researched and verified by the FileInfo team. We strive for 100% accuracy and only publish information about file formats that we have tested and validated.

If you would like to suggest any additions or updates to this page, please let us know.