Use column of data in query to SQL
I have a list of customer numbers in excel (2000 in column A).
I would like to use this list, and query the SQL Server to return their
first and last name, by matching the numbers in column A.
Can this be done without using a macro? I'm not very familiar with writing
VBA.
Or, if it can be done using a macro, and you have the code easily
paste-able, it would be appreciated.
Essentially, I want this.
Select no, fname, lname from cust
where no = {cycle thru column A}
|