• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1066
  • Last Modified:

Replace data in access table


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.

1 Solution
Helen FeddemaCommented:
You will need to run an update query to replace the old IDs with the new IDs in the table, linked by the Description field.  My recent Access Archon article on Fixing Normalization Errors may be helpful here.  Here is the link for downloading the article and sample database:
and here is a typical update query:
update query
simonwaitAuthor Commented:
Sorry I have got myself in a right muddle here with data.  Will sift through and then look at your suggestion cheers

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now