ODBC ms Query will not edit saved query

D

David

Hello,

I am using Excel to query an Oracle database. When using
Excel 97 and Windows95/98 all saved queries worked fine.
After upgrading to Windows2000 and Excel 2000 queries will
refresh data, but we cannot edit the queries. When we
choose "get external data / edit query" MSQuery appears to
flash on the screen for a split second and then vanish. I
have created system DSNs as instructed by Microsoft
Knowledge Base Article - 322046, but it did not correct
the problem. Any suggestions would be greatly appreciated.

THANKS,
David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switching ODBC sources in Excel 2007 1
Oracle ODBC Driver Errors 0
Error Editing an MS Query in Excel 1
Microsoft Query/ODBC issue 0
How to store a connection with parameters into a workbook 0
Excel 2003 Query Definition Disappears 0
ODBC query problem 3
Query via Import External Data doesn't reflect revised syntax 0

Top