Article ID: 173522 - Last Review: October 16, 2002 - Revision: 1.0

XL97: Error Adding Field to Query Using Query Wizard

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q173522
Expand all | Collapse all

SYMPTOMS

When you add a field to your query in the Query Wizard, you may receive an error message that is similar to the following
<Table>.<Column> is not a column of an inserted table, updated table, or any table identified in a FROM clause.
where <Table> is the name of the table you are working with and <Field> is the name of the field that you are trying to add.
Back to the top

CAUSE

This problem may occur when the following conditions are true:

  • You have created a correlation name or alias for a table that is the same as the name of an existing table in your database. -and-

  • You are using the Query Wizard to build your query.
Back to the top

RESOLUTION

To correct this problem, obtain Microsoft Excel 97 Service Release 2 (SR-2). For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:
151261  (http://support.microsoft.com/kb/151261/EN-US/ ) 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.
Back to the top

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).
Back to the top

MORE INFORMATION

Microsoft Query may build a query with an improper alias preceding the column name.

For Example the improper SQL syntax created is: 
   SELECT MSQRY32.COL1
   FROM DBO.MSQRY32 MSQRY32_0
The Expected Results are: 
   SELECT MSQRY32_0.COL1
   FROM DBO.MSQRY32 MSQRY32_0
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
  • Microsoft Query 2000
Back to the top
Keywords: 
kbbug kbfix kbqfe KB173522
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top