If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Default to No Primary Key on import
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 |
#3
|
|||
|
|||
Default to No Primary Key on import
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 |
#4
|
|||
|
|||
Default to No Primary Key on import
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 |
#5
|
|||
|
|||
Default to No Primary Key on import
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 |
Thread Tools | |
Display Modes | |
|
|