Microsoft Office Tutorials and References
In Depth Information
Importing or Linking to Data
Figure 4-7:
The Import
Spreadsheet
Wizard.
2. In the second window of the wizard, tell Access whether the first row
contains column headings; then click the Next button.
3. In the next window, change properties as necessary for each column
(click a column in the displayed data and change properties for that
field at the top of the window); then click the Next button.
This window allows you to further define each field by typing a field
name, choosing a data type, choosing whether to index the field, and
choosing to skip importing or linking to this particular field. You don’t
have to complete this information for each field; you can go with the
choices Access makes.
4. In the next window, select a primary key field, let Access create a new
AutoNumber field as the primary key, or specify that the table doesn’t
have a primary key field; then click the Next button.
5. In the last window, name the table; then click the Finish button.
The last window of the wizard contains a check box that runs the Table
Analyzer Wizard. If you choose to have the wizard analyze the table, the
Table Analyzer Wizard looks for duplicated data and recommends ways
to create multiple related tables that don’t contain repeated data. You
may also choose to display the Access help system when the wizard
is done.
When the wizard finishes, you see the Database window with your new
table listed.
Getting contacts from Outlook into Access
You can import contacts from Outlook into an Access table if you have
Outlook, Outlook Express, or Microsoft Exchange Server installed on your
Search JabSto ::




Custom Search