Select to view content in your preferred language

Sync excel edits to enterprise?

447
2
07-20-2017 08:20 AM
JuliaGerdes1
Emerging Contributor

Is it possible to link an excel spreadsheet, that is frequently updated, to a feature class related table in sde? How can I auto-sync frequent edits in an excel table that is connected to a related table and feature class in enterprise? Thanks!

0 Kudos
2 Replies
JonathanQuinn
Esri Notable Contributor

This will likely need to be done through some scripting or other third party tools.  This thread goes into some techniques:

https://community.esri.com/thread/65177 

0 Kudos
ThomasColson
MVP Frequent Contributor

Not entirely possible......you wouldn't be able to add rows to the excel table as you'd have to also figure out how to add a new objectid to each row.....which you could do if you were calling the SP that fired the new OID generation. This would be easier if you created a new table in SQL as the "back-end" for your excel table, and used triggers or SP's to accomplish the marriage with your SDE table. 

0 Kudos