MSQUERY: Syntax Error When Field Name Starts with a Number

• Microsoft Query for Windows, version 1.0
• Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, if a field name starts with a number, math operations involving the field may result in the following error message:

Syntax Error

WORKAROUND

To work around this problem, change the field name so that it does not start with a number.

REFERENCES

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

Q131162 "Syntax error in CREATE TABLE statement" with ODBC 2.0 Drivers

Additional query words: XL5 5.00 5.0 5.0a 5.0c 7.00 MSQuery

Keywords : xlquery
Version : 1.00 2.00
Platform : WINDOWS
Issue type :