topic Please help me with process to automate update from excel to enterprise geodatabase in ArcGIS for Excel Questions

Please help me with process to automate update from excel to enterprise geodatabase

t1alba — Wed, 31 Jan 2024 07:58:16 GMT

I will be receiving an excel spreadsheet with data points that have lots of associated information for each point. I will be getting this spreadsheet from an external source monthly/ biweekly. The points will mostly be the same but values in the fields will change with each update

I would like advice on an automated workflow to get this information into our organisations enterprise geodatabase for use in dashboards and web applications. My SQL server (SSMS)and programming skills is very limited but I am willing to try either approach as a steep learning curve to learn and improve my skills for this use case so that I am better prepared next time I encounter a task like this. My first thoughts are to try to do this in SSMS.I would really appreciate some guidance from any of you experts in this forum. How do you usually manage updates like this?

Re: Please help me with process to automate update from excel to enterprise geodatabase

JakeSkinner — Wed, 31 Jan 2024 11:56:26 GMT

Hi @t1alba,

This can all be accomplished in ArcGIS Pro. You can create a model that has the following tools:

Excel to Table - convert the Excel table to a geodatabase table
XY Table to Point - convert the geodatabase table to a feature class
Truncate Table - truncate the Enterprise Geodatabase feature class
Append - append the geodatabase feature class to the Enterprise Geodatabase feature class

Re: Please help me with process to automate update from excel to enterprise geodatabase

ShannonCardoza — Mon, 05 Feb 2024 20:18:07 GMT

We appreciate you reaching out @t1alba At this time, we do not support any type of automation in ArcGIS for Excel. I will, however, take this suggestion/idea to my team.

I can post updates here as I receive them.

All the best,