XL97: Error Adding Field to Query Using Query Wizard
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
