----- Original Message -----
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.
----- END Original Message -----
I've had to do this before, just import the Excell sheet into Access as a
table and run a query against the two of them.
MS Access usually has no problem importing Excell sheets (in the main window
just Right-Click, select "Import").
For your query you could do omething like this:
INSERT INTO tblCustInfo (account_Number, etc, etc)
SELECT accunt_Number, etc....
FROM tblEXCELL_IMPORT
WHERE account_Number NOT IN (
SELECT DISTINCT(account_Number)
FROM tblCustInfo
)
Hope that helps you out.
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "David Nesbitt" <[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)
