Microsoft Office Tutorials and References
In Depth Information
Importing data and objects from Access
Importing data and objects from Access
When you import from another Access database, you can
choose to import any combination of tables, queries, forms,
reports, macros, or modules. For each type of object, you have
the option to select all the objects or to select individual objects
of each type.
When importing related tables, you import the relationships by
default. Options are available to exclude relationships, to import
only structures and not data, and to create new tables when
importing data from queries rather than importing the query.
2
1
Import data and objects from an Access
database
1 Click Access in the Import & Link group on the External Data tab.
2 Keep the default selection to import tables, queries, forms, reports,
macros, and modules into the current database.
3 In the File Open popup window, browse to locate the database file.
Select the file, and click Open.
4 Click OK.
(continued on the next page)
4
3
Search JabSto ::




Custom Search