XL97: Data Returned from Only One Table Using Query Wizard
Article ID: 173121
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Query 2000
This article was previously published under Q173121
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:
151261 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).
Keywords: kbbug kbfix kbqfe KB173121