When adding a Microsoft Access table to ArcView using an SQL connection, the following error may occur:"[Microsoft] [ODBC Microsoft Access 7.0 Driver] Too few parameters.
SQL syntax error"
The field names contain spaces or special characters.
In the select clause of the SQL statement, add square brackets around the table name and field name for fields with spaces or special characters. For example:
select [table1].[field-1], [table1].[field 2], table1.field3
Get help from ArcGIS experts
Download the Esri Support App