English

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

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.