Creating Points from XY Coordinates from an Excel Spreadsheet

[KensieWorsham1]

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

[JoeBorgione]

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