RE: [CFTALKTor] OT - Excel or Access

[terry]

load the excel sheet into another table, then do a query that joins the two tables and voila you have every id that exists in both.   Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED]   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Wednesday, 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