RE: [CFTALKTor] OT - Excel or Access

[Dave Boehm]

If you load both into an access table, I believe there is a find duplicates function in the query wizard.   David Boehm Website & Database Management Product Ordering On-Line M&T Printing Group 907 Frederick St. Kitchener, ON Canada N2B 2B9 (519) 571-0101  Fax (519) 571-0129 [EMAIL PROTECTED]   -----Original Message----- From: Mike [mailto:[EMAIL PROTECTED]] Sent: March 13, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] OT - Excel or Access   Hello All,   This is a little off topic but I wondering if someone could help with this in either Excel or Access.     I have recieved a spreadsheet from a client that has a list of account numbers in one column and various other customer info.  I need to load these in a database but the list has account nubmers that alread exist in my database.  Is there a way to compare these two columns and produce a list of the dups? So that I can remove them.   Thanks   Mike