I have an access database which has a table called Assen, in the table is a field called AsNummer (unique numbers) and Description (Text). This table is then used as a lookup value in a number of other tables one of which is called Merkerlijst.
I have a copy of the database called old.mdb and a copy called new.mdb. In the new.mdb I have had to loose all the data from Merkerlist and change the Asnummer values for different row data. (ie Asnummer 12 with Description "Track 1" is now Asnummer 5)
I have also added some extra fields to new.mdb
I now need to import the data from old.mdb's Merkerlijst table but in a way that the new data has the correct and updated Asnummer.
I think I can create a list of old asnummers vs new as I guess thats necessary but not sure where to go from here.