I am creating a python script to update a feature class monthly from excel spreadsheet information. I have already worked out how to delete records that are no longer active as well as geocode and add new records, but I am also wanting to update any information that has changed without having to geocode it all again. I know the easiest way would be to just drop all the information and geocode and republish, but that will consume a lot of credits.
I have looked at a few different options like UpdateCursor or merging and dropping fields, but I have not gotten them to work. Does anyone have a better idea on how I could go about this?
XTools Pro Edit in Excel tool can do this.
I was hoping to have it be a standalone python script rather than having to use more tools. Thank you though!