Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit dqy file (Excel ODBC Query)
Is there a way to edit an existing .dqy file (Excel ODBC Query)?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
odbc error on Excel query into database | Excel Discussion (Misc queries) | |||
how to access databases from excel using ms query and odbc? | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Excel ODBC Query | Excel Programming | |||
EXCEL AND ODBC AND QUERY | Excel Programming |