Selecting 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
Appending Data to an Existing Table | Importing and Exporting Data | Selecting Records to Append | The Process of Exporting Data | Appending Data with the Import Wizard