XL2000: Edit Query Dialog Box Disappears When You Edit Oracle Query

When you use Microsoft Query in Microsoft Excel, and you try to edit a query that accesses data in an Oracle database, the Edit Query dialog box appears briefly and then disappears.

To work around this issue, use a System Data Source Name (DSN) instead of a File DSN when you set up your connection to the database.

For additional information about how to create and use System DSNs, click the article numbers below to view the articles in the Microsoft Knowledge Base: