Default to No Primary Key on import

[Peter Gr]

Hi gang,

On importing files into Access, is there a way to set the default in
the Import Wizard to "No primary key" instead of the "Let Access add
primary key". I don't see it in the options of Access.

Thanks

Peter

 

[Ken Snell \(MVP\)]

No way known to me.

 

[Wayne-I-M]

Best bet would be not to use the import wizard. Use an append query instead
- you have much more control and you get rid of the primary key if you want
(or add a new one)

 

[Pieter Wijnen]

Not so easy with most ISAM databases (oh it can be done, but requires more
knowledge than should be needed for this ng)
If you import the same Data (ie same table /structure) repeatedly, save the
ImportSpec
& Use
DoCmd.TransferDataBase Or DoCmd.TransferText Or DoCmd.TransferSpreadSheet
instead.
(Help on these can be accessed by Pressing Ctrl+G , Typing The Command,
Place Cursor & Hit F1)

HTH

Pieter

 

[Wayne-I-M]

I assumed that Peter had the abiltiy to palce the data into an access
database (any one will do on any drive). It sounds like he understands that.
If so, it is quite simple to bring in records from an external DB on to a
table in your working DB - you can get rid of the primary field (or any
others) add fields on the import or append, etc.etc. I use this quite a bit
to bring in new records for our field staff's lap tops (with a filter on the
append on the timedate stamp).

I think (may be wrong) but it is around the level that most users of the
forum would pick very quickly.

I can post a step-by-step if anyone is interested.