View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heprox heprox is offline
external usenet poster
 
Posts: 1
Default 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?