Discussion Locked

Access-AutoNumField on ImportSpec

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I add an AutoNumber Index Field on the Import Specification in MS-Access

1 reply

by desktroll

Chris, you can't add an autonumber field to an import spec.

You need to add the field after the import

run imporrt then to add an autonumber to your table run the following SQL, modifying as required.

alter table table1 add column Field1 counter

Change "Table1" to your table name, change Field1 to your field name.

This discussion is closed to new replies.