Add primary key to existing import spec

[Guest]

How do I add an Access generated primary key to an existing Import spec.

Thanks,
John

 

[Guest]

You don't say what format you're trying to import your data from, but I think
you can add an autonumber field to the table you're trying to import data to,
and then use an append query to append the data to the table. An append query
allows you to specify which fields get updated. An autonumber field should
automatically be updated each time a record is appended, even if the
autonumber field isn't included in the append query.

If your data is in Excel, you can also add a column for the primary key and
use AutoFill to fill the column with numbers, before you import the data to
Access.