Hi. I'm trying to join a n excel table to a shapefile with the Join command. The shapefile is a census file of block groups, and the excel sheet is some income data downloaded from American FactFinder. I am trying to join them based on their FIPS code. However, when I get to #3 in the join dialog box, the field that I should be joining it to does not appear. I've tried a few different configurations, duplicating the desired field in the xl file, changing the number format, saving it as a different nae, etc., but the result is the same. Any idea why this is not showing up as an option?
thanks in advance.