Linking a GIS layer with an Excel file

[DjalilDahhaoui]

Subject:
Linking a GIS layer with an Excel file.

I am looking into linking an excel file with a GIS layer so the user can open the Excel file and update the date (month/day/year) and
the GIS layer will reflect data for that specific day.

The GIS layer contains a field for Date (month/day/year).

Thanks,

[WadeLobb]

Right click on the feature class and got to joins and relates - select join

Once a join is created you can't edit the spreadsheet with Arcmap open

http://resources.arcgis.com/en/help/main/10.1/index.html#/About_joining_and_relating_tables/005s0000...

[MarkBoucher]

I just today learned that, with the right ESRI software purchase, you can bring the maps into Excel instead of Excel data into the maps.

http://www.esri.com/software/arcgis/arcgisonline/apps/esri-maps-for-office

[MarkYoung]

- but Maplex's solution is free.. Or if it's a point dataset you could just ensure that the spreadsheet has two fields for X and Y, load the spreadsheet into ArcMap, display XY so you can view the points. When the user updates the spreadsheet the the points in ArcMap are also updated but as previously mentioned you can't have the spreadsheet and mxd open at the same time or you will get locking issues.