XL: MSQuery: Cannot Open Q+E Query File |
The information in this article applies to:
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for Windows, version 7.0
SUMMARY
In Microsoft Query, you attempt to open a Q+E Query file (.QEF) containing a text, the following error messages will appear:
Error in Expression: field_1
-and-
Invalid column name: Field_1
MORE INFORMATION
The errors are caused by incorrect table information provided to Microsoft Query. Q+E is providing a Microsoft Query a field width that is different from the actual table width. This table information cannot be correctly interpreted. The solution is to create a new text data source and have Microsoft Query "guess" the new table information then load the old query (.QEF) file.
To create the new data source to open the Q+E query table, do the following:
- Run Microsoft Query.
- From the File menu choose New Query.
- Select Other.
- In the ODBC Data Sources dialog choose New.
- From the Add Data Source dialog box, select Text Files and choose OK.
- In the ODBC Text Setup, enter a name for the new data source and choose the Options button.
- Select the Directory button and choose the directory that contains the Q+E query file (*.QEF). Choose the OK button.
- Choose the Define Format button.
- Select the Q+E query file (*.QEF) and choose the Guess button.
- Choose OK until the Select Data Source dialog box appears.
- Select the newly created data source and choose the Use button.
- Now add the Q+E query table.
Additional query words: 5.00c query MSQUERY QplusE
Keywords : xlquery
Version : 5.00 5.00c 7.00
Platform : WINDOWS
Issue type :
Technology :
Last Reviewed: April 12, 2000 |