Cannot edit query.
 

Fred wrote:
I use Microsoft Query via Excel to pull data into a
spreadsheet. Occasionally I edit the query by
selecting "Edit Query" from the External Data toolbox.

The problem is that after accessing the data about five
times Microsoft Query will not open anymore. The data will
still refresh and the ODBC drivers are all working
properly, I just can't get to the SQL to edit it. Even
after rebooting I get nothing. I'm tired of retyping the
query and reformatting the spreadsheet when it stops
working.

If it matters I'm tapping a Oracle DB using an Oracle ODBC
driver.

Someone please help, what am I doing wrong?

I have the same problem with Oracle 9i. The best way to get around this
problem is to use VB & Dynaset. It makes like easier...