Yes, Use the GetString method from the Recordset object. Brian Silvers EDS [EMAIL PROTECTED] 817-963-5771 ----- Original Message ----- From: "jake williamson" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 10:19 AM 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]
