Autonumber Weirdness

[hi there]

Hi everyone,

i'm in the process of uploading some data from an Excel spreadsheet into an existing table and i'm getting some screwy things in my PK field. i'm using an autonumber field for my PK and i can get the data to import from Excel but instead of insert the record and creating the next sequential autonumber value and makes a radical jump. for example prior to my import i was at 927 then the next record entered went to 47517249 from there on they sequentially increased (47517250, 47517251,..etc) however what happened after 927. can anyone help me with this.

some background i have tried imported the data in the following ways each giving the same results:

1. bulk import from excel table to existing table
2. link to excel table and then run an append query
3. bulk import from excel table to new table then run an append query

many thanks for any help or suggestions.

 

[hi there]

hi pat,

thanks for the response. i was thinking about restarting the autonumber. this table has a one-to-many with another table (child). as an alternative to the append query, could i delete the relationship, delete the PK field in the table, and create a new PK autonumber field? are these methods comparable? if so, which method is preferred?

many thanks for your help.