Home > Articles > Home & Office Computing > Microsoft Applications

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

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. 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.

Import a Table from a Database

  • yellow_1.jpg Click the External Data tab.
  • yellow_2.jpg Click the Import Access Database button.
  • yellow_3.jpg Click Browse, locate and select the database file that contains the data you want to import, and then click Open.
  • yellow_4.jpg Click the import option you want.
  • yellow_5.jpg Click OK.
  • yellow_6.jpg Click the tables you want to import. To deselect a table, click the table again.
  • yellow_7.jpg Click OK.
  • yellow_8.jpg To save import steps, select the Save import steps check box, enter a name and description, and then click Save Import.

    Otherwise, click Close.

  • + Share This
  • 🔖 Save To Your Account