Microsoft Office Tutorials and References
In Depth Information
Importing or Linking Data From Other Applications to Access
AC 213
3
With the option
button to import the
data to a new table
selected, click the OK
button to display the
Import Spreadsheet
Wizard dialog box
(Figure 5).
Import Spreadsheet
Wizard dialog box
First Row Contains
Column Headings check
box (should be checked)
First Row Contains
Column Headings check
box (should be checked)
What happens if I
select the option
button to append
records to an
existing table?
Instead of the
records being placed
in a new table, they
will be added to the
existing table,
provided the value
in the primary key
fi eld does not
duplicate that on an
existing record.
data in
worksheet
Next button
Figure 5
4
If necessary, click
First Row Contains
Column Headings to
select it.
Import Spreadsheet
Wizard dialog box
Click the Next button
(Figure 6).
When would I
use the options on
this screen?
You would use
these options if you
wanted to change
properties for one or
more fi elds. You can
change the name,
the data type, and
whether the fi eld is
indexed. You also can
indicate that some
fi elds are not to be
imported.
fi eld options
Next button
Figure 6
Search JabSto ::




Custom Search