XL97: Data Not Returned from Query Using ORACLE Data Source

ID: Q168702

The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Query 97 for Windows version 8.0
WARNING: The information in this article has not been confirmed or tested by Microsoft. Some or all of the information in this article has been taken from unconfirmed customer reports. ANY USE BY YOU OF THE INFORMATION PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. 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.

SYMPTOMS

When you attempt 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 period of time, and then no data is returned to your worksheet.


WORKAROUND

To work around this behavior, use one of the following methods.

Method 1: Disable "Enable Background Refresh"

To prevent the query from being executed in the background, follow these steps:
  1. Create your query in Microsoft Query, and then choose to return the data to Microsoft Excel.


  2. Click the Properties button in the "Returning External Data to Microsoft Excel" dialog box.


  3. Clear the "Enable Background Refresh" check box, and click OK.


  4. Click OK to return the results of your query to the worksheet.


    5. NOTE: When the "Enable Background Refresh" option is disabled, you will not be able to perform other tasks when this query is executed.

Method 2: Move Your Mouse Pointer

If 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 of the data has been returned to Microsoft Excel. Please note that depending on your query, it may take several minutes to return the results of your query to the worksheet.

Method 3: Paste the Data into the Worksheet

To paste the data from Microsoft Query into the worksheet, follow these steps:
  1. In Microsoft Query, create the appropriate parameters for your query.


  2. Select an item in the data pane.


  3. Press CTRL+SHIFT+SPACEBAR to select all of the data in the data pane.


  4. Click Copy on the Edit menu.


  5. Activate Microsoft Excel.


  6. Click Paste on the Edit menu.


    7. The data will be pasted onto your worksheet.
NOTE: When you use this method, none of the parameters used to query your database are saved with the data, so the Refresh Data command cannot be used to update the results of the query. As a result, you must follow these steps each time the query requires an update.


MORE INFORMATION

This problem has been reported when querying an ORACLE 7.3 data source using the following ODBC drivers: 


   Filename       Version       File date
   --------------------------------------

   SQO32_73.DLL   2.00.0301     2/4/97
   MSORCL10.DLL   2.00.006325   1/12/97
SQO32_73.DLL is manufactured by Oracle Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.


REFERENCES

For more information about returning data to Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text

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.

Additional query words:

Keywords : kb3rdparty kbinterop xlquery
Version : WINDOWS:8.0,97
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: November 2, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.