Using a range of excel value as conditions in a SQL query

Question

I am trying to write a macro that queries the SQL database but enters a condition into the query. That condition is a range of values in a column in the spreadsheet.

So, I have "Sheet1", where column A is titled "code" with values from A2 onwards. I want to run a SQL query that says:

SELECT value FROM dbtable WHERE code = 'ValueFromA2'

With the result being populated in cell B2.

I then need to continue that query down through B3, B4, etc. until it's reached the end of the range of values in column A.

Is this possible?

Ilya Berdichevsky · Accepted Answer · 2019-01-25 15:51:16Z

0

Use Excel to create list of queries into the new column by concatenating your SQL logic with "code" values.

See this example: https://stackoverflow.com/a/16819629/327165
Use VBA to loop thru column with SQL queries and populate results into column B. As an option you can create queries in VBA.

See this example: SQL query in VBA, code stored in several cells in Excel

edited Jan 25, 2019 at 15:51

answered Jan 25, 2019 at 15:40

Ilya Berdichevsky

1,29810 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using a range of excel value as conditions in a SQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related