please help--I want to selectively replace data

  • Thread starter Thread starter town of scotland
  • Start date Start date
T

town of scotland

I am an ACCESS idiot and yet I find myself in the
position of having to create an antique tool inventory
database for a private collector. I work on entering the
stuff at home, and go to his house to update what I have
put on his computer--only to find that he has corrected
some records himself. How can I import my additional
data without writing over his corrections on the previous
data?
If you can answer this, I have a million more of 'em.
Thanks to anyone who takes pity on me.
--Penny
 
open his copy of database, then copy objects from your
copy..
then make a table query using his table and your tables
then probably another query to clean up the table
 
You could import your new data as a new table, then run
a "find unmatched" query between the old table and the new
one to show you which records in your new table aren't
already in the old one.
 
Back
Top