![]() |
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} |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com