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

When you import the wizard allows you to enable an automatic primary key or choose your own.

If you've macroed the process, I believe you should open the table in design, right click the field you want to be the primary key, and then click primary key.