Linking Excel Sheet to Point Data reference table using ArcMap?

Question

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.

Answer 1

You have three options at least.

1. Copy the values from "Field1" to "Field32".
2. Export your table from the Point Data Reference, copy the Excell Sheet info into it. Bring that back in to ArcMap as a .csv file and create a Shapefile/Feature Class from that using the "Display XY Data..." function in ArcMap.
3. Using a .csv file (i.e. saving your Excel file as that file type) will likely get rid of the issue as ArcMap will see the first row ("Field1", etc.) as simply a header and see the remaining rows in the first column for what they are - numbers. The link should then work.

Add a layer from a CSV file

Answer 2

You are joining with "Field32" instead of "Field1". Why "Field1" is not available in the list? Likely because it has a different data type (I guess string) than FID