I have set up an import specification to import a table from excel into my database.

When I choose the spec and import it, everything happens as it should which includes Access adding its own Primary Key ID Field.

I have written a macro to carry out the import and chosen the import spec as above but it will not add a primary key ID Field.

I have tried following the import wizard and then doing a "Save As" to rename the spec but it will not add a primary key field.

Or can i use a macro to add a new field to the table and then make it the primary key

Any help appreciated