Import to ID field with an existng ID

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

is there a way to import a set of data that has a pre existing unique
Identifier so that this unique ID is populated into the ID field?
 
Jeff,
I have a similar issue. Hopefully the same answer from someone will help us
both. First, I exported a table from Access 2007 to Excel 2003. This brought
along my PK auto-number field (“IDâ€). I learned from many attempts to delete
the “ID†column before I import back into Access. In my db I have records
1-50 that were entered thru an input form in the db, now I have a request to
import 1,200 records from this .xls , after deleting the “ID†column to make
the import work I now see in the auto-number field in my table go from 1-50,
then the next record is 68432-69633. It probably doesn’t matter but how can I
maintain an accurate, sequential auto-number when importing?

-Pete
 
I would import the data, and then run an append query to append the
values into your final table. You can append the existing identifier
into the ID field (assuming it doesn't already exist, in which case
you'll get an error when appending).

Joan Wild
MS Access MVP
 
Back
Top