0

I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data to the point file. When I use Joiner in FME or load data tool in ArcGIS it appends the data rather than updating.

1
  • Welcome to GIS SE! Would you be able to edit your question to clarify whether your geodatabase table is stored in a file geodatabase (*.gdb) or an ArcSDE geodatabase (in Oracle, SQL Server, PostgreSQL, etc) or another geodatabase type, please?
    – PolyGeo
    Sep 7, 2014 at 1:05

2 Answers 2

1

When using FME, rather than using a joiner factory open the properties of the the writer and go to the parameters tab.
In there change the writer mode from INSERT to UPDATE. Then set your unique key field in the Update Key Columns field. Here's a link that may help Editing Writer Properties

1

Yes to MickyT's answer - and also the DatabaseUpdater transformer might be of use.

Also, there's an FME Tutorial on Spatial Databases at: http://www.safe.com/learning/training/on-demand/tutorials/ which I happen to know covers updates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.