Database Reference
In-Depth Information
If you use Microsoft Outlook and want to create an Outlook task to remind you to
run the import process at some specific time in the future, select the Create Outlook
Task check box.
3
Click Save Import .
4
TIP If you chose to create an Outlook task, Outlook opens a task window that
already contains information about the task. You simply set a due date, make any
other necessary adjustments to the settings, and click Save & Close in the Actions
group on the Task tab.
To run a saved import operation:
In the Import & Link group on the External Data tab, click the Saved Imports
button.
1
Click the import you want to run, and then click Run .
2
TIP If you have created an Outlook task for the import process, you can click Run
Import in the Microsoft Access group on the Task tab of the task window.
In the sections that follow, we discuss some of the issues to bear in mind when importing
data from a specific source.
Importing from other Access databases
Suppose you have one Access database that includes tables of information about products
and orders and another that includes customer contact information. You want just one
database containing all the information. You can save time by importing the product and
order information into the contacts database (or vice versa), rather than re-creating it all.
10
You can easily import any of the standard Access objects: tables, queries, forms, and re-
ports. (Macros and modules can also be imported, but they are beyond the scope of this
topic.) When you import a table, you have the option of importing only the table deini-
tion (the structure displayed in Design view), or both the definition and the data. When
you import a query, you can import it as a query or you can import the results of the
query as a table.
TIP If you need only some of the fields or records from a table in another database, you
can create a query in the other database to select only the information you need and then
import the results of the query as a table. Alternatively, you can import the table and either
edit it in Design view or clean it up by using queries.
 
Search WWH ::




Custom Search