I need some code to do a database lookup for each cell in specific cell range
that is not emply (e.g. a2-a250) and return a single record from the database
with a select using the value in that cell in the where clause.

I'm thinking the sql will be something like: "select jobname from jobs where
jobid = " (i don't know how to put in the cell reference, or the vb code
around it)

Can someone help me?

We're in the same boat, I am trying to do same thing, I
know it can be done, just can't figure out how to do it.

If you ever get yours to work I'd appreciate knowing how
you did it. Thank you.
Jean



-----Original Message-----
I need some code to do a database lookup for each cell in
specific cell range
that is not emply (e.g. a2-a250) and return a single
record from the database
with a select using the value in that cell in the where
clause.

I'm thinking the sql will be something like: "select
jobname from jobs where
jobid = " (i don't know how to put in the cell reference,
or the vb code
around it)

Can someone help me?

.