Is This Content Helpful?
We're glad to know this article was helpful.
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