I have datasets in a File GDB Feature Class and an Excel table. I want to join them on a field named JOINFIELD. I have the same field name in the FC & in the top line of a column in the Excel sheet. When I am choosing the fields for the join I see the one in the FC, then I select the Excel file to join to it but the drop down menu does not show my JOINFIELD from the excel file, so I can not join on it.
If I do the reverse, bring the Excel table into ArcMap and try to join to the spatial FC I do see the JOINFIELD in the Excel table join options but once I point to the FC to join to the JOINFIELD does not appear in the drop down menu of fields to join on from the FC, even though I know it is there.
I have tried changing the Excel file to .csv but no change.
The values in the JOINFIELD are numeric and I have confirmed they are identical in both the FC and the Excel table. There is only 4 records so it should have little problem joining.
Why do the fields not show for joining?