topic Re: Linking a GIS layer with an Excel file in Data Management Questions

Linking a GIS layer with an Excel file

DjalilDahhaoui — Tue, 02 Jul 2013 15:17:06 GMT

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,

Re: Linking a GIS layer with an Excel file

WadeLobb — Tue, 02 Jul 2013 20:53:55 GMT

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/005s0000002n000000/

Re: Linking a GIS layer with an Excel file

MarkBoucher — Tue, 02 Jul 2013 21:18:19 GMT

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

Re: Linking a GIS layer with an Excel file

MarkYoung — Wed, 03 Jul 2013 06:11:26 GMT

- 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.