How to validate data using MS Access

[maniii]

HI can any one help me in validating data using Ms Access by comparing two files (not by querying).
I have two records A and B which is having almost same data, now I need to validate these two records and save the records in Excel sheet.
Can anyone help me out with this.

[orange]

More info please. Can you post a sample of the data and what result you expect?

[rpeare]

And what do you mean by 'validate' are you attempting to get rid of duplicates in your database or are you trying to force two different records to be identical?