ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit dqy file (Excel ODBC Query) (https://www.excelbanter.com/excel-programming/347685-edit-dqy-file-excel-odbc-query.html)

RalphIBower

edit dqy file (Excel ODBC Query)
 
Is there a way to edit an existing .dqy file (Excel ODBC Query)?

K Dales[_2_]

edit dqy file (Excel ODBC Query)
 
Yes. You can go into MSQuery and open the file then edit it. You can either
go to MSQuery from Excel (Data... Get External Data... New Database Query)
and then open, edit, and save the file - even if you never return the values
to Excel ("Cancel and return to Microsoft Excel").

But you can also open MSQuery directly - it is an .exe file in your Office
program file folder (MSQRY.EXE). Then create and edit queries to your
heart's content!
--
- K Dales


"RalphIBower" wrote:

Is there a way to edit an existing .dqy file (Excel ODBC Query)?



All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com