Importing Data into Tables

You can create new tables from other Access databases by importing and linking tables. When you import a table, you copy data from a table in one Access database and place it in a new table in your database. When you link a table, the data stays in its original location, but you can display and access that data from within your database. If data in the original database changes, the changes will appear in your linked database, too. You can also import data from other programs. When you import data from some programs, such as Excel, Access uses a wizard to help you set up the data as a table.

Import a Table from a Database

In the Database window, click the New button.

Double-click Import Table.

Locate and select the database file that contains the data you want to import, and then click Import.

Click the tables you want to import. To deselect a table, click the table again.

Click OK.

Import Data from Another Program

In the Database window, click the File menu, point to Get External Data, and then click Import.

Click the Files Of Type list arrow, and then click the type of file you want to import.

Locate and select the file, and then click Import.

If necessary, follow the instructions in the wizard.