• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Importing and Exporting Info... > Importing or Linking Data from an Ac...

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

Open the database in which you want to import data.

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

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

Locate and select the database from which you want data.

Click Import.

Click Options.

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

Click the objects you want.

To deselect an object, click it again.

Select the import options you want.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint