Has anyone figured out a way to tell ArcGIS that the field type in a table is something other that what it guesses?
I want to JOIN the client's list of ZIP codes to a ZIP code shapefile and eventually make them different colors. But when Arc imports the Excel or CSV file, it looks at the first eight records, sees that the ZIP codes are all numeric digits, and declares the field type to be Double rather than String. Thus, the JOIN command will not show the field I want to join on. I cannot find any way to instruct Arc that I want the field type of a column in a newly imported table to be String.