To append one table to another:
- On the TABLE tab, in the Edit group, click Append Rows to open the Append Table dialog box.
- Choose the table you want to append from. Select a table in the Append Table drop-down list.
- Choose the table you are appending to. Select a table in the To Table drop-down list.
- Click OK. The status of the append operation displays.
- Click Stop to halt the append process.
When the columns of the two tables are not ordered properly, so that columns with corresponding positions do not have corresponding data, use Modify Structure (From the TABLE tab, click Table and select Modify Structure) to change the order of the columns in one of the tables.
You can use SQL Select to reorder the columns of one of the tables and then append the results.
See Also: