[ Team LiB ] Previous Section Next Section

Importing or Linking Data from an Access Database

If you have data in another Access database, you can import the information using the Import command. During the importing process, you select the tables you want to import. If you import a table that is already linked, Access links the table to its data source. In other words, Access copies the link to the table. If you link to a file on a network, make sure to use the full path name, such as \\server\share\path\file name (for example \\Server1\Projects\Data\Sales.mdb), instead of a mapped drive to avoid linking problems.

Import Data from an Access Database

graphics/1_icon.jpg

Open the database in which you want to import data.

graphics/2_icon.jpg

Click the File menu, point to Get External Data, and then click Import.

graphics/3_icon.jpg

Click the Files Of Type list arrow, and then click Microsoft Office Access.

graphics/4_icon.jpg

Locate and select the database from which you want data.

graphics/5_icon.jpg

Click Import.

graphics/6_icon.jpg

Click Options.

graphics/7_icon.jpg

Click the tab with the Access database object you want to import.

graphics/8_icon.jpg Click the objects you want.

To deselect an object, click it again.

graphics/9_icon.jpg

Select the import options you want.

graphics/10_icon.jpg

Click OK.

graphics/11inf02.jpg

Did You Know?

You can delete the link to a linked table. In the Database window, click Tables, click the linked table you want to delete, and then press Delete.


Link Data from an Access Database

graphics/1_icon.jpg

Open the database in which you want to link data.

graphics/2_icon.jpg

Click the File menu, point to Get External Data, and then click Link Tables.

graphics/3_icon.jpg

Click the Files Of Type list arrow, and then click Microsoft Office Access.

graphics/4_icon.jpg

Locate and select the database from which you want data.

graphics/5_icon.jpg

Click Link.

graphics/6_icon.jpg Click each table to which you want to link.

To deselect a table, click it again.

graphics/7_icon.jpg

Click OK.

graphics/11inf03.jpg

Convert a Linked Table to a Nonlinked Table

graphics/1_icon.jpg

In the Database window, select the linked table you want to convert.

graphics/2_icon.jpg

Click the Copy button on the Database toolbar.

graphics/3_icon.jpg

Click the Paste button on the Database toolbar.

graphics/4_icon.jpg

Type a name for the new table.

graphics/5_icon.jpg

Click the Structured Only or Structure And Data option.

graphics/6_icon.jpg

Click OK.

graphics/11inf04.jpg

    [ Team LiB ] Previous Section Next Section