I am trying to join an excel spreadsheet to the attribute table of project locations in ArcMap. The excel CSV file is in my layers and I can open and view it as an attribute table. However, it is when I try and join the two attribute tables by FID that I encounter some problems. After selecting that I want to join by the FID field, I am unable to select the corresponding field in the table. (See pictures)
Essentially I a trying to create a reference map of all my projects. I dropped points at all the project locations on ArcMap and now I would like to link the data table with all the project info to those points.
If there is an easier/better way to do this, I am open to suggestions. I have a Microsoft Access database with the project info in it, but I don't really know how to access and link it in ArcMap.