Microsoft Office Tutorials and References
In Depth Information
Importing or Linking Data From Other Applications to Access
AC 217
Importing from or Linking to Data in Another Access
Database
Just as you can import data from an Excel worksheet, you can import data from
another Access database. Similarly, just as you can link to data in an Excel worksheet, you
can link to data in another Access database.
Identify sources of external data for the database: Access database.
You need to decide whether it is appropriate for you to import or link data in another
Access database. The following are some common reasons for importing from or linking to
another database:
1. You want to combine two databases into one. By importing, you can copy all objects
(tables, queries, forms, reports, and so on) from one database to the other.
2. You want to create tables that are similar to tables in another database. When importing,
you can choose to copy the table structure without the data. The table created in the
process will have all the fi elds and fi eld properties of the original, but will be empty.
3. You want to copy a collection of related objects from another database. In one operation
you could, for example, copy a table along with all queries, forms, and reports that are
based on that table.
4. You have several databases, but data in some tables is the same, for example, the
Client table must be shared between some of the databases. By linking, any updates to
the table in the source database are immediately available to anyone using any of the
other databases.
Plan
Ahead
T O I MPORT D ATA FROM A NOTHER A CCESS D ATABASE
The following steps would import data from another Access database into the
database that is currently open.
1. Click the Access button in the Import group on the External Data tab.
2. Select the database containing the data to be imported.
3. Be sure the ‘Import tables, queries, forms, reports, macros, and modules into the
current database’ option button is selected and click the OK button.
4. In the Import Objects dialog box, select the tables, queries, forms, reports, macros,
and/or modules you wish to import and then click the OK button.
5. Decide if you wish to save the import steps.
T O L INK TO D ATA IN A NOTHER A CCESS D ATABASE
The following steps would link tables in another Access database into the database
that is currently open.
1. Click the Access button in the Import group on the External Data tab.
2. Select the database containing the tables to be linked.
3. Click the ‘Link to the data source by creating a linked table’ option button to link and
then click the OK button.
4. In the Link tables dialog box, select the tables you wish to link and then click the
OK button.
Search JabSto ::




Custom Search