Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: Merging tables/ searching across multiple tables

    I have a problem that I am stumped as to how to solve.

    I have multiple databases with several people who are in more than one of the databases. I have merged all the databases into one file by creating a new file and importing all the old databases as new tables. My problem is that there are no unique identifiers that identifies each individual!!! I need to get a list of everyone who is duplicated in more than one table so that I can create a "key table" where everyone can be listed and assigned a unique identifier. I have no idea how to go about this short of manually typing in each persons name in each table to see if they come up.

    Any ideas?

    P.S. I am very new to this so may need babied through the steps .

  2. #2
    Join Date
    May 2011
    The easiest/fastest way I found to do this, is by exporting the table with the duplicate records into an excel worksheet, opening it into excel & using the "advanced sort" to remove duplicates.

    If you need further explanation on how to accomplish this... I recommend typing "how to remove duplicate rows in excel" into

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts