Joining Textfile to Shapefile Differences in ArcGIS versions

Discussion created by mary1001 on Jun 19, 2014
Latest reply on Jun 19, 2014 by mary1001
I am trying to join a textfile generated in stata that includes caoname, caoid, and fips. The fips code should match to a shapefile county map that matches to the cntyidfp category. In ArcGIS 10.0, doing a straightforward join based on these attributes works. However, in 10.2, ArcGIS only allows for the joining of the cntyidfp to the caoname, which is completely useless. What's the difference between the two versions that makes this difficult? I have tried exporting to an excel document first, ensuring both the fips and cntyidfp data have the same number of characters, and creating a new table of the textfile within arcgis, but none of these solutions seem to work. What am I missing? Any insight would be appreciated, thank you.