Default to No Primary Key on import

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

No way known to me.

--

Ken Snell
MS ACCESS MVP


"Peter Gr" wrote in message
...
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

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)


--
Wayne
Manchester, England.



"Peter Gr" wrote:

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

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" wrote in message
...
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)


--
Wayne
Manchester, England.



"Peter Gr" wrote:

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

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.

--
Wayne
Manchester, England.



"Pieter Wijnen" wrote:

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" wrote in message
...
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)


--
Wayne
Manchester, England.



"Peter Gr" wrote:

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