MS SQL Excel Sheet Match Search

• phylox

  SSC Veteran

  Points: 204

  More actions

  July 5, 2010 at 2:13 pm

  #223493

  I have an excel sheet with two columns that have first and last names of clients in a database.

  In the database there is a table named users with first / last / and email.

  I basically want to get these first last names on the excel sheet, and find all matches in the database with their corresponding email address from the database and return the result.

  What would be the best way of doing this? Here's a quick overview of what I said above:

  excel sheet 2 columns

  first | last

  client database 3 columns in table users

  first | last | email

  sql query to run a find match on all names from excel sheet, then the database table named users, and return the matching email for each first / last name on the results.

• Denesh Naidoo

  SSCrazy

  Points: 2348

  More actions

  July 6, 2010 at 3:25 am

  #1188986

  Hi,

  Create a new table in the database with columns First, Last.

  Import the data from the Excel file into the new table.

  Run a query join the existing table and new table.

  Delete new table created.

  Thanks

  Denesh