How to compare two tables in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All!
I need some help with comparing tables in MS Access 2000.

There are two tables with exactly the same fields.
One table may contain more records than the other and vice versa.

I need to compare two tables in a database and filter out the records that
are mismatching and export it in a new table.

I also need to create a new table with all the records that are in table 1
but not in table 2, and another table with records which are in table 2 but
not in table 1.

I'm novice to Access and i'm not into programming..so i would like to know
if a standard code/ template that is already available to perform this
function..?

Any inputs on this will be highly appreciated!
Thanks
Futureer
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Compare records in same access table 0
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
eleminate same records in two tables 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
check first 3 characters of a cell and compare to a table 4
Comparing two tables 6

Back
Top