cell references excel
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?