Article ID: 168702 - View products that this article applies to.
This article was previously published under Q168702
WARNING:This information is preliminary and has not been confirmed or tested by Microsoft. Use only with discretion. Some or all of the information in this article has been taken from unconfirmed customer reports. Microsoft provides this information "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
When you try to return data from Microsoft Query 97 to a Microsoft Excel 97 worksheet, the spinning globe icon (which signifies that a query is processing) may appear for a long time, and then the query returns no data to your worksheet.
To work around this problem, use one of the following methods:
Method 1: Turn Off the Enable Background Refresh SettingTo prevent the query from running in the background, follow these steps:
Method 2: Move Your Mouse PointerIf you move your mouse pointer continuously while the data is being returned to Microsoft Excel, the query may not fail. Do not stop moving the mouse until all the data has been returned to Microsoft Excel.
NOTE: Depending on your query, it may take several minutes to return the results of your query to the worksheet.
Method 3: Paste the Data in the WorksheetTo paste the data from Microsoft Query in the worksheet, follow these steps:
This problem has been reported when querying an ORACLE 7.3 data source by using the following ODBC drivers:
Sqo32_73.dll is manufactured by Oracle Corporation. Microsoft makes no warranty, implied or otherwise, regarding this product's performance or reliability.
File name Version File date -------------------------------------- Sqo32_73.dll 2.00.0301 4-Feb-1997 Msorcl10.dll 2.00.006325 12-Jan-1997
For more information about how to return data to Microsoft Excel, click the Index tab in Microsoft Excel Help, type retrieving data from external databases, and then double-click the selected text to go to the "Ways to retrieve data from an external database" topic.
Article ID: 168702 - Last Review: October 21, 2002 - Revision: 1.0