XL97: Data Returned from Only One Table Using Query Wizard

ID: Q173121

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Query 97 for Windows

SYMPTOMS

When you use Microsoft Query to return data from more that one table in a database, only data from the first table is returned to your Microsoft Excel worksheet.

CAUSE

This problem occurs when the following conditions are true:

Two or more of the tables included in your query have the same name.
```
    -and-
```
The tables with the same name have been defined with different owners in the database.
-and-
You are using the Query Wizard to build your query.

RESOLUTION

To resolve this problem, obtain Microsoft Office 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q151261
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-2

To work around the problem temporarily, click to clear the "Use the Query wizard to create/edit queries" check box in the Choose Data Source dialog box.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Query 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

Additional query words:

Keywords          : kbdta
Version           : WINDOWS:97sr2
Platform          : NT Win95
Hardware          : x86
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: November 4, 1998