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 records from another 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.) In the following example, we will link data from another Access database.
|
There are many sources from which you can gain the information, including Microsoft Excel, dBASE, and others. The database we want is the EMPLOYEES database. There is an employees table in it. The next screen will allow us to select as many tables as we wish from it. |
 |
The only table is EMPLOYEE LIST, so it is added. Notice the arrow to indicate the linked table to the right. |  |
 |
 |
 |
 |
last modified 10/20/98 pjm