Home > Commands > Database > Import / Export Data > Append Data

Append Data

The Append Data command copies a ProVal database onto the end of the current database. The appended data is added as new records following those that already exist in the database.

Note: If you want to combine two files by adding new fields instead of new records, use the Merge Data command instead of Append Data. To append data from an ASCII text file, use the Import Data command.

Select the file to append to the current database file allows you to choose the database to append to the current database. This command shows the names of ASCII files in the database directory specified for the current Client.

Select fields to append lists the names of all fields in the selected file, and an asterisk (*) is shown to the left of fields that are also defined in the current database. Select any number of fields to copy.

If you copy any fields that do not yet exist in the current database, those fields will be created in the current database and will be initialized with missing values before the new data is appended. Fields in the database that do not exist in the appended file will be filled with missing values in the appended records.

Selection Expression limits the number of records appended.