Import Wizard-Change the default to "No Primary Key&quo

[ryan_quirk]

Is there any way to change the default to "No Primary Key" instead of "Let Access add primary key" I have Specs set up for everything import into Access, and everytime I import something I have to manually select "No Primary Key"

 

[Joe4]

Re: Import Wizard-Change the default to "No Primary Key

If you are importing into the same table, or using the same format every time, you can set and save Import Specifications.

When you are going through the Import Wizard, if you click on the Advanced button, you will see that you can set and save an Import layout (where you can set the "No Primary Key" option).

Then when you import files in the future, simply open the Import Specs (by clicking on the Advanced | Specs) and click Finish.