Return
-
Title
Does the Import Utility Wizard append or overwrite information? -
Description
Does the Import Utility Wizard append or overwrite data when importing tables? I exported multiple tables using Export Utility Wizard and am now trying to import the .dmp file to update my database. I am weary of duplicate data if I import into an existing table.
-
Resolution
Import Utility Wizard's import table will append data.
If you do not have unique values constraints it you can get duplicate data. If duplicates is a problem, truncate data from the table before importing.