ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Database query with a range of cells as paramters? (https://www.excelbanter.com/excel-discussion-misc-queries/126681-database-query-range-cells-paramters.html)

heprox

Database query with a range of cells as paramters?
 
I have a spreadsheet with Column A is a value. I have an Oracle
database that contains all of the values from Column A and has another
field in it that I would like to place in Column B in the spreadsheet.
I've created the necesarry MS query and it takes the parameter from
Column A and returns the value to Column B.

How do you get it to do the same thing repeatedly using each row in
Column A? I don't want to have to repeat the same query manually for
all 3000 rows?



All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com