I need to write a query that has a variable reference in it, i.e. 'name' SELECT * FROM Table Where Name = 'name'

names are defined in a range in excel, i.e. use C6:C1000 (some cells may be empty)

the program should keep executing the sql statement until it gets to cells that are empty ... any ideas?

thanks.