Import Spec

[Andy Munn]

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

 

[Rich_Lovina]

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.