Error: SQL statement failed to parse

Error Message

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.