Microsoft KB Archive/173522

= XL97: Error Adding Field to Query Using Query Wizard =

Article ID: 173522

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q173522





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

. is not a column of an inserted table, updated table, or any table identified in a FROM clause.

where  is the name of the table you are working with and  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:

151261 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

Keywords: kbbug kbfix kbqfe KB173522

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.