Import with Automatic gen of Primary Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing data from excel to access and I want access to generate the
value for primary key. When I remove the primary key column from my
database, the import fails. How can I get access to put a random automatic
number in the primary key field and add my rows?

thanks, Joyce
 
Create the table with Autonumber field along with the other fields and then
append on import.
 
Thanks Karl. I am using the online gui to do my import (eventually will
write a procedure to import).....where is this option to "append" in the
online gui?
 
Back
Top