Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default edit dqy file (Excel ODBC Query)

Is there a way to edit an existing .dqy file (Excel ODBC Query)?
  #2   Report Post  
Posted to microsoft.public.excel.programming
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)?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
odbc error on Excel query into database flowry Excel Discussion (Misc queries) 2 November 6th 08 09:26 PM
how to access databases from excel using ms query and odbc? Nabin Excel Discussion (Misc queries) 0 October 11th 06 07:32 AM
Edit Query from Excel will not open query in MSQuery Michelle Excel Programming 0 February 21st 05 03:59 PM
Excel ODBC Query H. Zhu Excel Programming 1 December 12th 03 03:42 AM
EXCEL AND ODBC AND QUERY Gary B[_3_] Excel Programming 1 August 5th 03 02:39 AM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"