Skip to main content
edited title
Link
PolyGeo
  • 65.5k
  • 29
  • 115
  • 353

Problem Linking Excel Sheet to Point Data reference table using ArcMap?

Source Link

Problem Linking Excel Sheet to Point Data reference table

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.

Project location reference table

Excel sheet in ArcMap

Trying to join

results