How to: Select Fields to Append
You may want to append only certain fields from your source file. You can select the fields to include in the Append From process.
To select fields to append
From the Table menu, choose Append Records.
In the Append From dialog box, enter the source file type and name, and then choose Options.
In the Append From Options dialog box, choose Fields. The Field Picker dialog box displays the fields in the destination table.
Select fields that match those you want to append from the source file and choose move, then choose OK.
The fields you select appear in the Selected Fields box.
Choose OK.
See Also
Tasks
How to: Append Data to Existing Tables
How to: Select Records to Append
How to: Append Data with the Import Wizard