Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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} |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic URL for first column of data from excel query? | Excel Discussion (Misc queries) | |||
Dynamic URL for first column of data from excel query? | Excel Discussion (Misc queries) | |||
Scan and remove column data query | Excel Discussion (Misc queries) | |||
Scan and remove column data query | Excel Worksheet Functions |