I have tested a thought I had regarding the difference between the files that
won't generate a query wizard and those that do. I opened a file that does
work and changed the criteria from a single date definition as defined in the
source data (Last 12 months) to using a different date field and defining it
as =01/04/05 & =<31/12/05. Using this definition the query wizard returned
the required data, but when trying to generate the query wizard again I got
the message again that the query wizard could not be used, followed by a
window to edit the query in Microsoft Query

"MargaretBeckbury" wrote:

The query wizard window does not generate at all, instead I get the message
quoted. At the same time it generates Microsoft Query for me to be able to
edit by this method, but this is a more complex and time consuming way to do
things. The query wizard has generated perfectly well on other queries I've
created.

"Ron Coderre" wrote:

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?