Extract text from Excel ODBC queries (DQY)
To convert DQY queries to another format, you need Microsoft Excel or other Database software.
To convert other file formats to the "Excel Data Query" file type, you need software like Microsoft Excel or a similar tool.
A .DQY file is an Excel ODBC Query File used by Microsoft Excel to connect to an external database and retrieve data into a spreadsheet. These files do not hold any actual row or column data. Instead, they store plain-text connection strings, server credentials, and SQL commands necessary to perform the database query.
Sharing a .DQY file is highly problematic. It requires the recipient to have the exact same ODBC (Open Database Connectivity) drivers installed, network access to the target database, and valid login credentials. Without these, the file is completely useless. Furthermore, opening an unknown query file poses a massive security risk, as it can execute unverified scripts against connected servers.
People usually want to convert a .DQY file into a data format like XLSX or CSV. However, standard online converters fail to process this conversion. They cannot run the query because they do not have secure network access to your private or corporate database. Often, only the original software can properly read or export the data by running the query locally.
Despite these limits, convert.guru provides a practical workaround. Just drag and drop your file to identify the format, view it, and convert it when possible. Because the file stores text, our analysis can safely inspect the internal connection strings and SQL commands. You can view the raw code or convert the text into formats like TXT or SQL without triggering the actual database connection.
Convert.Guru analyzes your DQY file, detects the exact format, and lets you read the text inside.
Users also converted QEF, XLA and ODC files.
If you want to convert DQY file to DB, SQLITE, SQLITE3, MDB, ACCDB, DBF, ODB, FDB, GDB, MYD, FRM or SQL, you can use Microsoft Excel or similar software from the "External Database Data Query" category. In the File menu, look for Save As… or Export….
To convert NDF, SQLITE3, BAK, RDB, SQL, DB4, MDF, MDB, LDF, DB, DB3 or SQLITE files to DQY, try Microsoft Excel or another comparable tool in the "External Database Data Query" category.
The history of Convert.Guru began over 25 years ago in California with Tom Simondi’s file-format database. A former contributor to Space Shuttle development and a software pioneer of the 1980s, Simondi established a trusted resource for file type analysis that was even referenced by Microsoft Windows XP. Today, we use modern technology to process and convert thousands of file formats while continually improving our DQY converter.