Microsoft Office Tutorials and References
In Depth Information
Importing or Linking to Data
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 that appears, name the table by typing a name in
the Table Name box; then click the Finish button.
The last window of the Import Text Wizard contains a check box that
runs the Table Analyzer Wizard. If you choose to have a wizard
analyze the table, the Table Analyzer Wizard looks for duplicated data and
recommends how 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 you click Finish, Access creates the new table and lists it in the
Click the Advanced button in the last window of the wizard to display the
Import Specification or Link Specification dialog box again. If this operation
is an import or link that you may want to repeat, save the specs by clicking
the Save As button.
The Import Specification dialog box, shown in Figure 4-6, displays all the
specifications for the text-file import. You can edit these specs, save them,
or import specs that you created and saved when you did another text-file
import. This dialog box has options that you’ve seen before in the wizard
(such as those for file format, field delimiter, and text qualifier), as well as
the following options:
that you can