autonumber access

Results 1 to 2 of 2

Thread: autonumber access

  1. #1
    Join Date
    Dec 1969

    Default autonumber access

    I have an Access database with an autonumber ID column. <BR>Someone that doesn&#039;t have Access needed to change the data so I exported the whole table to an Excel spreadsheet. Now I need to re-import it into Access but I need to keep the ID&#039;s intact (not re-number) and keep the autonumber on the ID column. How?

  2. #2
    Join Date
    Dec 1969

    Default RE: autonumber access

    Two ways:<BR><BR>1) Import the spreadsheet into a new table and then run an update query linking on the Autonumber column in the two tables<BR><BR>2) Delete all the data in your original table, repair and compact the database and then import the spreadsheet into a temp table and do an append query. This will use the autonumber Ids from the original table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts