Home > Articles

  • Print
  • + Share This
This chapter is from the book

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. You can also import data from other programs. After you select the table you want to import during the import process, you have the option of saving the import steps for use again in the future.

Import a Table from a Database

yellow_circle_1.gif Click the External Data tab.

yellow_circle_2.gif Click the Import Access Database button.

yellow_circle_3.gif Click Browse, locate and select the database file that contains the data you want to import, and then click Open.

yellow_circle_4.gif Click the Import tables, queries, forms, reports, macros, and modules into the current database option.

yellow_circle_5.gif Click OK.

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

yellow_circle_7.gif Click OK.

yellow_circle_8.gif To save import steps, select the Save import steps check box, enter a name and description, and then click Save Import.

Otherwise, click Cancel.

  • + Share This
  • 🔖 Save To Your Account