XL97: Error Adding Field to Query Using Query Wizard

ID: Q173522

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Query 97 for Windows

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.

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.

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:

   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).

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

Additional query words:

Keywords          : kbdta
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: November 4, 1998