Microsoft Office Tutorials and References
In Depth Information
Importing or Linking Data From Other Applications to Access
AC 215
8
Click the Save import
steps check box to
display the Save
import steps options.
If necessary, type
Import-Computer
Items in the Save as
text box.
name of saved
import steps
description of
saved import steps
Type Import data
from Computer
Items workbook
into Item table
in the Description
text box (Figure 10).
When would I create
an Outlook task?
If the import
operation is one
you will repeat on
a regular basis,
you can create and
schedule the import
process just as you
can schedule any
other Outlook task.
Save Import
button
check this box to
create an Outlook task
Figure 10
9
Click the Save Import button to
save the import steps (Figure 11).
default table
table just imported
Figure 11
Other Ways
1. Right-click Table1 :
Table in Navigation
pane, point to Import,
click appropriate
fi le format
Using the Access Table
After the Access version of the table has been created, you can use it as you would
any other table. You can open the table in Datasheet view (Figure 1b on page AC 207).
You can make changes to the data. You can create queries or reports that use the data in
the table.
By clicking Design View on the table’s shortcut menu, you can view the table’s
structure and make any necessary changes to the structure. The changes may include
changing fi eld sizes and types (for those that may not be correct), creating indexes, specifying
the primary key, or adding additional fi elds. If you have imported multiple tables that are to be
related, you will need to relate the tables. To accomplish any of these tasks, use the same steps
you used in Chapter 3.
Search JabSto ::




Custom Search