Microsoft Office Tutorials and References
In Depth Information
AC 214
Access Integration Feature Sharing Data Among Applications
5
Because the Field
Options need not
be specifi ed, click
the Next button
(Figure 7).
option button to let
Access add a primary key
option button to
choose primary key
option button to
omit primary key
Figure 7
6
Click the ‘Choose
my own primary
key.’ option button
(Figure 8).
click arrow if you need
to select a different fi eld
as the primary key
How do I decide
which option button
to select?
If one of the fi elds
is an appropriate
primary key, choose
your own primary
key from the list of
fi elds. If you are sure
you do not want a
primary key, choose
No primary key.
Otherwise, let Access
add the primary key.
option button to choose
primary key selected
correct fi eld already
selected for primary key
Next button
Figure 8
7
Because the Item Id
fi eld, which is the
correct fi eld, is
already selected as
the primary key, click
the Next button.
message indicates
that the import
process is complete
Be sure Item appears
in the Import to
Table text box.
Click the Finish
button to import the
data (Figure 9).
Close button
check box to save
import steps
Figure 9
Search JabSto ::




Custom Search