invalid SQL statement was used

Error: An invalid SQL statement was used

In ArcMap, when attempting to display X and Y coordinate data in a table from a CSV file, the following error occurs.

Solution: Do NOT use banned names for header of your excel file. 

 

• Comply with formatting conventions when naming the fields to ensure ArcMap recognizes the field names set in a table to display the X and Y coordinate data. Reserved words cannot be used as field names, and field names must start with a letter and can only contain letters, numbers and underscores without any spaces.