why not do the test before you load into the database? I assume you will be loading them into a CF-run database? If so, the CF can check whether the account exists in the DB and if it does, either update the information which already exists or don't load the new info into the DB.
carina ----- Original Message ----- From: Mike <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 10:02:40 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 - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
