An invalid SQL statement was used

Error Message

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

Error:    
An invalid SQL statement was used.

Cause

This error occurs due to one of the following reasons:

• Not exporting the X, Y event layer permanently after adding the X and Y coordinate data to the map.
• Proper formatting rules are not adhered to when naming the X and Y coordinate fields.
• The X and Y coordinate fields have text set as data type instead of numeric data type.

Solution or Workaround

There are three possible solutions for this issue, depending on the cause.

• Make the X, Y event layer permanent by saving the X and Y coordinate data as a shapefile in a project folder, or as a feature class in a file geodatabase. When the X and Y coordinate data are added to the map, it becomes an X, Y event layer. In ArcMap, event layers are designed to be temporary, which means the event layers defined during a session do not persist after the session ends.
• 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.
• Convert the X and Y values to decimal degrees, and store the values as a numeric field because coordinate value is recognized as numeric data. Refer to ArcMap: Adding x, y coordinate data as a layer for more information.