I have successfully joined a point shapefile to .CSV file in ArcMap 10.0, and the type of the fields which are related in the two files are the same(text, length:255). But when I remove join and relate the two files, open the attribute table of the shapefile, and click the "Related Table" button, the option is greyed out…
How can I solve this problem?
[GIS] Relating shapefile to excel table in ArcMap
arcgis-10.0arcgis-desktoparcmapexcelrelates
Best Answer
The help for ArcGIS is clear that you cannot do relates with Excel documents or any other document that does not support an ObjectID in the Fundamentals of ObjectID fields help.
This help clearly states:
"If your table lacks an ObjectID field, you won't be able to perform the following operations:
These limitations are only some of the many reasons I always convert Excel and CVS data to geodatabase tables. Indexing is another very big reason to not use these formats if you are dealing with data of any significant size. The performance and functionality gains of conversion far outweigh the inconvenience of having to maintain a one-off version of the data in ArcGIS.