Microsoft Office Tutorials and References
In Depth Information
Importing data from text files using specifications
Import data from a text file
14 Allow Access to add a primary key, or choose a column to use as the
primary key. Click Next.
15 Type a name for the imported data table, and click Finish.
TIP When importing data Access gives you three choices for
setting the new primary key on a table. The simplest option is
to accept the default choice and Let Access add primary key, this will
add an autonumber field called ID to your table.