topic Re: Using a Join w/ Excel in ArcGIS Pro Questions

Using a Join w/ Excel

mkhenson — Thu, 21 Apr 2022 16:55:45 GMT

Greetings everyone....I am using a join (excel) to connect to some points in my arcgis pro map. I have gone in to the excel spreadsheet and changed the name of one of the headings. When I re-open my gis map, that heading has not changed. What do I do? Remove the join and reconnect? Thanks for any input you can give me.

MKH

Re: Using a Join w/ Excel

DanPatterson — Thu, 21 Apr 2022 18:00:29 GMT

remove the excel file. Fix it up, then use the Excel To Table file to make a geodatabase table. do the join with it

Re: Using a Join w/ Excel

mkhenson — Fri, 22 Apr 2022 13:19:56 GMT

problem is that this spreadsheet will be constantly changing. Probably not the headings, but the contents within the cells will.

Re: Using a Join w/ Excel

Robert_LeClair — Fri, 22 Apr 2022 15:21:19 GMT

Another idea since you have to use the Excel file as it updates regularly is create a model in ModelBuilder that exports to a fGBD (or eGDB) table, perform the join and work with the data daily. In fact you can schedule the model to run every period of time that you wish - daily, once a week, every six hours, etc. Then you'd be working with (somewhat) near real time updates.