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 PROTECTED]
