consolidating overlapping lists in access

  • Thread starter Thread starter Kevin.Gilnack
  • Start date Start date
K

Kevin.Gilnack

we have recently created a new mdb file to use as our master database.
i need to import data from our old database, our email listserv, and
numerous smaller excel and access lists. much of the information,
especially in our master db and online list is overlapping.

what is involved in telling access to prompt me when there is a
duplicate entry being imported, so i can select which data from the
entries to keep. if that involves extensive programming, what can i do
to prevent the import of dupes, but get a list of them to update
manually?

thanks for your help!
 
If you can write some queries, this should not be too difficult.
If, rather than directly importing the external data, you link to it, you
can then run a query to look for duplicates between the two tables and make
whatever adjustments are called for.

If you find linking to be a problem, import the data to a temporary table
and run the queries against them.
 
Back
Top