If they're spreadsheets, it's much easier to have Excel point out the
differences. Just create a third worksheet and put this formula into
cell A1, replacing FIRSTSHEET and SECONDSHEET by the actual names:
=IF(EXACT('FIRSTSHEET'!A1,'SECONDSHEET'!A1),"","DIFF")
Then drag the little handle at the bottom left of this cell to the right
for the width of the area you're interested in; next drag it down to the
last row. The sheet will now show the "DIFF" in every cell where the
corresponding values in the other two sheets aren't the same.
If they're not spreadsheets but Access tables, things can get more
complicated. Start by pressing F11 to display the Database Window. Then
go to the Insert menu and select Query. This brings up the New Query
dialog; select the Find Unmatched query wizard and follow the
instructions.
How do I take two spreadsheets that contain similar data
and have access point out the differences?
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
