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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top