View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default 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)?