Home » Infrastructure » Windows » Unable to EDIT Query - Excel 97
Unable to EDIT Query - Excel 97 [message #100066] Wed, 03 July 2002 10:35 Go to next message
Daniel Taillon
Messages: 2
Registered: July 2002
Junior Member
Has anyone else run into the following problem:
Using Excel 97, I have been able to create a query using Data -> Get External Data -> Create New Query.
But if, after having returned the data to Excel, I want to modify the query, using Data -> Edit Query does nothing.
(The message "Waiting for data to be returned from Microsoft Query" appears briefly in the Status Bar, but MS/Query does not launch).

This seems to be a problem ever since we installed the ODBC driver for the Oracle 8 database (8.01.66.00). The application is running on a P4, with Windows NT 4 SP6. This problem has appeared on a number of workstations using the same ODBC driver.
Re: Unable to EDIT Query - Excel 97 [message #100184 is a reply to message #100066] Tue, 27 August 2002 16:53 Go to previous messageGo to next message
Gary Lehto
Messages: 1
Registered: August 2002
Junior Member
Did you find a answer?
Re: Unable to EDIT Query - Excel 97 [message #100187 is a reply to message #100066] Wed, 28 August 2002 04:20 Go to previous messageGo to next message
Daniel Taillon
Messages: 2
Registered: July 2002
Junior Member
With respect to not being able to EDIT a query within Excel 97, we have tickets open with both Oracle and Microsoft, who have finally been able to reproduce this in the lab. We are still waiting for both firms to establish what needs to be corrected and for any patches to be made available.
Re: Unable to EDIT Query - Excel 97 [message #100232 is a reply to message #100066] Sun, 15 September 2002 23:28 Go to previous messageGo to next message
Ajith Thomas
Messages: 1
Registered: September 2002
Junior Member
Did you get a fix for this problem? Please post the solution if you have. Thanks
Re: Unable to EDIT Query - Excel 97 [message #100330 is a reply to message #100066] Wed, 16 October 2002 14:21 Go to previous messageGo to next message
Brian Washburn
Messages: 1
Registered: October 2002
Junior Member
Have you tried updating your Oracle ODBC driver to 8.01.07.00 in SQORA32.DLL dated 5/11/00?

I don't have that problem, and my machine matches your OS config and Office suite config, with the exception of your Oracle Driver being used.
Re: Unable to EDIT Query - Excel 97 [message #100443 is a reply to message #100330] Thu, 02 January 2003 03:01 Go to previous messageGo to next message
Jan Heirwegh
Messages: 1
Registered: January 2003
Junior Member
We are working with an Oracle ODBC driver 8.01.07.00 (SQORA32.DLL dated 5/11/00) and we still have the same problem !
Sytem : Windows 2000 + Excel 2000
Re: Unable to EDIT Query - Excel 97 [message #141510 is a reply to message #100066] Mon, 10 October 2005 11:21 Go to previous messageGo to next message
waewoo
Messages: 1
Registered: October 2005
Junior Member
Hello

Does anyone has found how to solve this problem ?

thanks
Re: Unable to EDIT Query - Excel 97 [message #278694 is a reply to message #141510] Mon, 05 November 2007 07:14 Go to previous message
crescent7
Messages: 1
Registered: November 2007
Junior Member

Dear Friends,

Even i was getting the same error from months.
Also couldn't get any solution from most of the forums.

Finally i could debug it myself.

Error i Was Getting when trying to Get external data from new database query:
In the excel status bar it was showing "Waiting for data to be returned from microsoft Query" and the excel would hang.

Operating System Using : Windows XP
Microsoft Office Version : Office 2000
Oracle Database Using : Oracle 9i

Solution: (Am not sure if this works for every one, but no harm in trying)
1) Open a blank excel
2) Go to tools menu --> Click on Add-Ins
3) You would find MS Query Add-in and ODBC Add-in
4) Make sure to check the boxes against these 2 Add-Ins
5) Click OK and close the excel
6) Restart the system (Very important step)
7) Open a blank excel
Cool Go to Data menu --> Get External Data --> New Database Query
9) Within few seconds --> Choose Data Source window will pop up


Regards
Chandru Cool
Previous Topic: Error coming while installing
Next Topic: Changing the current directory while running an SQL script
Goto Forum:
  


Current Time: Thu Mar 28 09:43:47 CDT 2024