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.