I have an excel spreadsheet where the user enters a name and address. This name and address will be sent back to a table in MS Access. How do I check for complete or partial matches of the name and address entered on the Excel Sheet? If it is already in the DB do nothing, if not add it.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!