I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field type for the excel file is a Double.
The excel field is all numbers, but the shapefile field is mostly numbers and a few letters mixed in, I think thats why it came out as a string.
I know you can't add a field or use the field calculator into a table exported from excel, I'm currently using it as a .csv.