If you have MS Access, you can copy and paste an Excel Spreadsheet directly to the Database window (tables tab) in Access. Then, you can query your table against the spreadsheet table:
Select "Not In Spreadsheet" as Discrepancy, T.DealerName >From DealerTable as T Where Not Exists (Select 1 From Sheet1 as S Where S.DealerName = T.DealerName) UNION Select "Not In DealerTable" as Discrepancy, S.DealerName >From Sheet1 as S Where Not Exists (Select 1 From DealerTable as T Where T.DealerName = S.DealerName) HTH, Tore. -----Original Message----- From: jake williamson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 11:19 AM To: ActiveServerPages Subject: multiple name database check up hello! we've just finnished a site with a dealer listing in it. our client has now sent us an excel sheet with over 100 dealers in it to 'check' if they are in our database.... obviously i dont want to go through each name!! is there anyway i can build an sql statement that says: select DEALERNAME from DEALERS where DEALERNAME like 'all the names in my spreadsheet' where 'all the names in my spreadsheet' would be the names from my excel sheet formated into a string, eg: dealer one, dealer two etc. they can be separated by any delimiator to get them into the string (by doing find and replaces in excel.) is there an easy way to do this??! many thanks, jake --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
