Microsoft Office Tutorials and References
In Depth Information
Getting Data from Another Access Database
Running and scheduling saved imports
If you saved the definition of an import or export operation while using
the appropriate wizard, you have the option of running the same import
or export again. Click the Saved Exports button in the Export group on the
External Data tab of the Ribbon to open the Manage Data Tasks dialog box,
where you can see all saved import and export definitions. The dialog box
has two tabs: Saved Imports and Saved Exports. From this dialog box, you
can run an operation, create an Outlook task, or delete a saved operation.
You also have the option of changing the source or destination file; click the
filename to change it.
Book II
Chapter 4
If you create a task in Outlook, you can go to the Outlook task to add a date
or define a recurrence. You can run the task straight from Outlook by
clicking the Run Export or Run Import button on the Ribbon when the Outlook
task is open.
Getting Data from Another Access Database
If the data you need is already in an Access database, decide whether you
want to import it or link to it. Refer to “Importing or Linking to Data,” earlier
in this chapter, if you need help deciding whether to link or import data.
You can also use the following procedure to import another database object
(such as a query, form, or report).
If you want to import or link to a table and all its data from another Access
database, the process is simple. Follow these steps:
1. Open the database where you want to use the data.
2. Click the Access button in the Import group on the External Data tab
of the Ribbon.
Access displays the Get External Data dialog box (refer to Figure 4-3,
earlier in this chapter).
3. Browse to the database that has the object you need, and click Open.
4. Choose Import or Link.
Either option results in a new database object; no option appends data
to an existing table.
If necessary, you can use an append query to combine two tables after
you import the data.
5. Click OK.
Access displays the Import Objects dialog box, shown in Figure 4-9 (or
the similar Link Objects dialog box).
Search JabSto ::

Custom Search