BUG

Not able to append records to an existing Personal Geodatabase (MDB) or File Geodatabase (GDB)

Last Published: April 25, 2020

Description

Any attempt to write records to an existing Personal Geodatabase or File Geodatabase overwrites the entire Geodatabase instead of appending.

Cause

This is a known problem.

Workaround

Add a new line to the header file of the Spatial ETL Tool:

  1. When editing the Spatial ETL Tool, select Tools > Edit Header... in Workbench.
  2. Scroll to the first START_DEST_HEADER and add the OVERWRITE_GEODB
    line as seen in the example below:

    Code:
    #! START_DEST_HEADER GEODATABASE_FILE GEODATABASE_FILE_1
    #
    ========================================================================
    ====
    # The following GUI line prompts for a directory to be used as the
    # the destination for the GEODB files.
    # The user input is stored in a macro, which is then used to define
    # the dataset to be written.
    # *******************************************************************
    # * Add the ArcGIS 9.2 DataInteroperability overwrite setting here.
    # * Note how this overwrite name begins with "GEODATABASE_FILE_1"
    # * just as seen in the "START_DEST_HEADER" line above.
    # *******************************************************************
    GEODATABASE_MDB_1_OVERWRITE_GEODB NO


    Note:
    If are working with File Geodatabase, add the following line instead:
    GEODATABASE_FILE_1_OVERWRITE_GEODB NO

  3. Click OK and save the Spatial ETL Tool.
  4. In ArcGIS Desktop, ensure that the Geoprocessing 'overwrite outputs' option has been selected in Tools > Options > Geoprocessing > Overwrite the outputs of geoprocessing operations.

Article ID:000009174

Software:
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options