Append

On the File tab, in the Actions group: Click Append to copy the records from one file and append them to another file that has the same structure. Some incompatibilities between the structures are allowed, like the fields having a different width, for example.

One situation where you can use this is when your files become very large.

For example, when you merge new assay results into a large file, it can be more efficient to create a new file with the same structure as the main file, import the new data and manipulate it, and then append the file to the original database. Note that file structures must be the same. To change a file structure so it can be used in Append, use Modify File Structure on the File tab, in the Actions group.

You can append files from the same or from different projects.

1. On the File tab, in the Actions group, click Append.

2. In the Append File form, enter the file name for the Output file. The Output file must exist in the current project.

3. If the source file is in the current project, then make sure the Current project option is selected. Otherwise, unselect the Current project option and double-click in the Project response box to nominate a different project.
4. Double-click (or click on the Select icon) to select the name of a source file. Files from the current (or selected) project will be displayed in the File Selection dialog.
5. Define a filter to selectively control which records will be processed.
6. If you want to append files with different structures, select Allow Incompatibility. This allows for differences in field width or number of decimal places between the files. However the number of fields and their position has to be identical.
7. Click OK.