repeats

[mtairhead]

I have 17 different excel sheets with one type of data. Every excel file contains records of people's first name, last name, phone number, etc. The only problem is that there are record repeats. For example, FileOne.xls has the a record that is also located on FileSix.xls.

If I import all of these sheets into Access as seperate tables, and then merge them in a union query, is there a way to compare records, and eliminate repeats based on phone number?

Thanks

Andrew

 

[Friday]

You will need to create a master table with the phone number field set as indexed-no duplicates. Then append each table (exported in from Excel) to the master table. Any duplicates will be rejected.