Adding Table Data to an Existing File

When exporting table data to an existing file, you can append data to the file, add a new table to the file or replace an existing table in the file.

Go to Export Design.
Select a table export on the Exports selector.
On the General tab of Excel Output panel, under Export Options, enter or select an existing table in Table Name. (Click Show Tables
Do one of the following:
- Select Add data to File from the When output files exist: drop-down.
- Select Add data to table from the When output tables exist: drop-down.
Select Accept to accept the definition, Cancel otherwise.

Notes:

For database formats: if you entered a new table name to add a new table to the file, this adds a new database table to the file. For spreadsheet formats: a new named range is added, either to the existing worksheet tab or as a new worksheet tab (depending upon the spreadsheet format).
If you choose to append data to an existing table, Monarch Classic performs a check to ensure that the fields (columns) you are exporting from Monarch Classic match those in the selected table. The following requirements must be met:
- For each column in Monarch Classic's Summary window, there must exist a field with the same name and type in the target table and that field's size must be greater than or equal to the size of the corresponding Monarch Classic column.
- No fields may be missing from the target table and no additional fields must be present.