Creating Points from XY Coordinates from an Excel Spreadsheet

KensieWorsham1 — Mon, 19 Sep 2011 13:15:06 GMT

I have a license of ArcView and I am trying to create a shapefile of traffic counts. The Excel file that I have has both Latitude and Longitude and they add as an event through the add xy data function, but whenever I go to export them to a shape file I receive this error:

One or more layers failed to draw:

Traffic_Counts: Syntax error (missing operator) in query expression 'LONGITUDE >= 1.#QNAN0 AND LATITUDE >= 1.#QNAN0 AND LONGITUDE <= 1.#QNAN0 AND LATITUDE <= 1.#QNAN0'.
Traffic_Counts: An invalid SQL statement was used. [`'Asc Parish$'`]

Do any of you have any ideas, they will be greatly appreciated.

Thanks,

JKW

Re: Creating Points from XY Coordinates from an Excel Spreadsheet

JoeBorgione — Mon, 19 Sep 2011 13:48:40 GMT

Check your data for null or some other weird value. You could also try to select a few and export them; if that works, then you've got a problem somewhere in the data. And, check the field names; excel is famous for spaces or special characters that ArcGIS does not like

topic Re: Creating Points from XY Coordinates from an Excel Spreadsheet in Data Management Questions

Creating Points from XY Coordinates from an Excel Spreadsheet

Re: Creating Points from XY Coordinates from an Excel Spreadsheet