« How can i change the values in combox1 according to the values selected in combobox2 in MS-Access?
Can I remotely manipulate data in a Microsoft Access database with a Blackberry? »

Can you compare two excel spreadsheets in Microsoft Access to pull duplicates?

In Microsoft Access 2003, can you compare two excel spreadsheets so that you can see if there are any duplicate entries?

Is there a wizard that does this?

There is a wizard that will find duplicates within a single table, but not between 2 tables. But it is very easy to make your own query to find out if there are duplicates. Make a new query. Put a join on each field in the two spreadsheets. I assume that the spreadsheets are linked to your database or that you have imported them so they are available as tables.

This entry was posted on Monday, November 16th, 2009 at 11:39 pm and is filed under microsoft access. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Can you compare two excel spreadsheets in Microsoft Access to pull duplicates?”

  1. Sandy Says:
    November 17th, 2009 at 5:24 am

    There is a wizard that will find duplicates within a single table, but not between 2 tables. But it is very easy to make your own query to find out if there are duplicates. Make a new query. Put a join on each field in the two spreadsheets. I assume that the spreadsheets are linked to your database or that you have imported them so they are available as tables.
    References :

Leave a Reply