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.

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:

Q151261 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
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug