Home > Articles > Home & Office Computing > Microsoft Applications

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

This chapter is from the book

Linking to Data in Tables

You can create new tables from other Access databases by importing and linking tables. 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. After you select the table you want to link during the linking process, you have the option of saving the import steps for use again in the future.

Link to Data 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 Link to the data source by creating a linked table option.
  • 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 Cancel.

  • + Share This
  • 🔖 Save To Your Account