Microsoft Office Tutorials and References
In Depth Information
Getting Data Out of Access
Figure 4-9:
The Import
Objects
dialog box
allows you
to import
database
objects from
another
Access
database.
6. On the Tables tab, select the table you want.
To select multiple objects, Ctrl+click and/or Shift+click. Click the Select
All button to select all objects displayed on the current tab (all tables,
for example). Click the Deselect All button to deselect all objects on the
current tab.
Click the Options button and choose the Definition Only option if you
don’t want to import the data — just the table definition (table
properties and field definitions).
7. Click OK to import the objects or create the link.
The new objects appear in the Database window. You can view and edit
them just as you would any other database objects.
You can use this method to import any database object — not just tables.
Getting Data Out of Access
You can export any object from an Access database to another Access
database or to a file that isn’t an Access file (an ODBC or Excel file, for example).
You can also use this technique to create a static HTML file.
Exporting is a convenient way to go about moving data from one Access
database to another. You can export an object without any data, such as
when you want to reuse a query definition. Exporting is similar to importing;
the difference is which database you have open when you start.
You can even save your export definition if you export data to another
application frequently. Notice the Saved button in the Export group on the
External Data tab of the Ribbon.
Search JabSto ::




Custom Search