How to return sql query results for multiple rows in excel where each row has parameters

Asked Oct 14 '19 at 19:55

Active Oct 15 '19 at 10:19

Viewed 348 times

I have an EXCEL spread sheet with 3000+ rows, i need to search a sql db to verify that a record exist for that row's data.

I have reviewed How to use parameterized query in Excel using column as parameter?. I can make it work for each row if I do a query for each row's parameter. but not for all 3000+. I also do not need the "column header" in the results.

I would like to have a query for each row for their parameters such as i have three columns Location, CityCode, CountyCode I want to return the MasterID which is Selecdt masterid where location = a1 and citycode = b1 and CountyCode = C1, for all 3000 rows.

edited Oct 15 '19 at 10:19

Vadim Kotov

8,084
8
48
62

asked Oct 14 '19 at 19:55

Lee Hopkins

Always helps to say what type of database you're working with. – Tim Williams Oct 14 '19 at 21:34
Sorry I am working with SQL – Lee Hopkins Oct 15 '19 at 10:01
SQL is a language used by many databases - do you mean Microsoft SQL Server? – Tim Williams Oct 15 '19 at 14:59
Yes I am working with MS SQL (2014) – Lee Hopkins Oct 16 '19 at 11:01

How to return sql query results for multiple rows in excel where each row has parameters

0 Answers0