View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cksiz cksiz is offline
external usenet poster
 
Posts: 2
Default 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}