Access 97. A user created a new database and imported data into two tables (A and B) from two different excel spreadsheets (which he deleted) so that he could consolidate the information from the two into a single table in the database for ease of administration. The two spreadsheets should have contained exactly the same information, however we are not sure they did.
I have been tasked with producing a list showing what information is held in Table A that is not in Table B (which would showthe discrepancies that may have existed between the two spreadsheets). I have very little time to do this. Someone help!
Job on the line