MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 2: MS Access Local & Linked Tables
Creating Linked Tables
On the other hand tables having structure as well as the data residing
in other databases (e.g. Oracle, MS SQL Server or even another MS Access
database) outside of your MS Access database are called External or
Linked Tables. Whenever you want to link to external table then click on
“External Data” command on the menu bar as first step. Then you will get
lots of data import features on the ribbon. Let’s suppose you want to
link to another MS Access database table then click on the “Access”
command on the ribbon as shown in Figure 2-12.
Once you are in “Get External Data” window, using the <Browse> button
locate the database. Then select the “Link to the data source by
creating a linked table” option.
Figure 2-12: Under “External Data” command we have lots of Import
(external data import or linking) & Export features.
________________________________________
After clicking the <OK> button, another window will pop up which you will use to locate the table to be linked as shown in Figure 2-13. If the table resides in database like Oracle, MS SQL Server, MySQL etc. then first you need to setup the ODBC connection whereas if the table to be linked resides in the other MS Access database then all you have to do is to select that database and finally the table. No ODBC connection is needed in this case.
Figure 2-13: Select the external table to be linked.
________________________________________
Chapter 2: MS Access Local & Linked Tables
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: