Rows missing from old table with no primary key

[Ruegen]

I have an old table from a database with 2000+ rows deleted and it had no primary key (but it had a number column).

I am splitting another old table which relies on the number column of that old table but I am importing it into a new table with an autonumber primary key which the split table will rely on.

Thing is I need the number and the autonumber to match up accross all records

1 has to be 1


2 has to be 2 and so on

is there a way to "fill" in rows with the missing numbers? i.e. if I have 1,2,3 and 2 is missing the method adds a row "2" to the table.

as you can see ... I have a problem

[Ruegen]

Also if this helps, if the other table can have their records match oldSchoolsID (that is what they used to be related to) but then updated to the new ID from auto field that would be better - saves me having to worry about inserting rows.

so tblBookings instead of 2613 now gets 2616 in its row field

[Ruegen]

Nevermind answered my own question and I am stoked.

I added a field and updated it with the autonumber from the other table and it matches so I am not worried about retaining the old ID and can use the new one.