XL97: Error Adding Field to Query Using Query Wizard

Retired KB Content Disclaimer

View products that this article applies to.

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

kbbug kbfix kbqfe KB173522

Back to the top

Retired 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