ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Use column of data in query to SQL (https://www.excelbanter.com/excel-programming/401840-use-column-data-query-sql.html)

cksiz

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