Error: SQL statement failed to parse
Attempting to create a relate, or execute commands such as DBMSEXECUTE, DBMSCURSOR, and DBMSINFO on a Microsoft Access table produces the error:
SQL statement failed to parse:
select * from county-data
The table name contains a hyphen, which causes a parsing error.
Solution or Workaround
Rename the table in Access and remove any hyphens.