I have just completed testing on a rewrite of an old Access database tool. the original plan was to just archive the old tool and start fresh with the new tool. HOWEVER, now management wants to bring the data into new tool. doing the remapping of the data to the new structure is not a problem except for the fact one of the key fields in the new tool is an AutoNumber field and i will have to map it directly to a non-autonumber field in the old data. there are a good number of skipped numbers in the sequence (1,2,5,6,10,......) what is the best way to move the data and keep the sequencing as it is in the old data. Access will not allow me to just paste the data without it renumbering.