Keeping some data but keeping the last primary key

[superrob5]

I am now pretty much finish with a database that I am converting over from 2 to 2000. The question I have is I don't need all the data but would like to keep the unique primary key which is an autonumber. The other data will be archieve onto backup tapes, cd and will still be able to be viewed on the network

What I would like to know is how can I import those records keeping the primary key and continuing with the number that it would. I tried to import it to the same table but becasue there is aprimary key access doesnt want to override it? ALso once you put data in a non autonumber field it says you can't change the field?

 

[Pat Hartman]

Use an append query to select the records you want to keep and append them to the new table. As long as the autonumbers are unique, all the rows will be added. The next autonumber assigned will be n+1 with n being the value of the highest existing autonumber.

 

[superrob5]

for some reason this time it worked. i tried it about a week ago and got errors so no worries thanks