Need to create point shapefile from table with county and route data

Discussion created by on Feb 4, 2014
Latest reply on Feb 10, 2014 by pmcatnip
My issue is..... I have an excel table of "projects" that also have fields called route #'s, county, state. I want to create a point shapefile for each project based off those 3 fields. The location does not have to be exact, as long as the project is somewhere on the correct route, in the correct county and state. I have over 1,000 records so I want to either use an ArcGIS tool or python script, or both to do this in a few steps rather than manually digitizing points. Any advice? Example : Project A, Route 83, York County, PA.