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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options