| |
Importing
and Linking Tables
The information
you need for your database may not be contained within it.
Since Access only works with one database at a time, you may
wish to either import or link data from another source. The
key difference lies in the status of the data. If you import,
you are copying the table into your database from an outside
source. If you link, you are merely making a connection to
the data; the data remains in its original location. Either
way, you can do this from the File|Get External Data menu.
(Both dialog boxes even look the same, so use caution.)
For example,
we will link the Employees table from its original source.
When you go to link or import, the source can be another Access
database, an Excel spreadsheet, or it can come from programs
such as Paradox and dBase. (up to dBase 5) If your table is
linked from an outside source, it will be indicated by an
arrow as shown below.
|
