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.