ofcabbagesandkings
New Member
I'm really at a loss here and it seems to be such a simple task that I must be missing the forest for the trees. I am given an excel 2007 worksheet with columns of part numbers, descriptions etc. which usually is no more than one hundred rows. I need to access an external database AS400(DB2) and run a query against a table with the same fields, compare the columns and highlight the differences between them. I'll connect with ODBC and probably use VLOOKUP for comparison. The part that is tripping me up is how to specify the sql parameters when setting up the query. In my SELECT* I want to pass in the values from a range of cells if possible, say A1:A75 by highlighting the range or by using a function. Any suggestions?