View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Get External Data - not editable using Query Wizard

Are you able to view the query window at all?

Without more details about your query, it's difficult to say what the exact
issue is. In general, though, the MS Query wizard will not be able to
graphically display certain types of queries (eg Union Queries). In those
cases, you need to click the [SQL] button to make changes to the SQL.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"MargaretBeckbury" wrote:

I have imported data using Get External Data and then tried to edit it via
Get External Data/Edit Query, but I get a message "This query cannot be
edited by Microsoft Query". I can't understand why I get this message or how
to access the query wizard under these circumstances. I even re-created my
query from scratch in case it was due to anything I added to the file, but I
still get the same message in the newly created query. How can I
re-establish the Query Wizard?