How to: Append Data with the Import Wizard
The Import Wizard asks you a series of questions and appends the data from the source file based on your answers. Using the wizard, you can choose to map the source fields to the destination fields by changing the column numbers.
To append from a file with the Import Wizard
From the File menu, choose Import.
From the Import dialog box, choose Import Wizard.
Follow the instructions on the wizard screens.
See Also
Tasks
How to: Append Data to Existing Tables
How to: Select Fields to Append
How to: Select Records to Append