SQL statement failed to parse

Last Published: April 25, 2020

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.

Article ID:000003466

  • ArcMap 8 x
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic