Thread: Want to use Excel column cells as parameters to SQLSERVER query

What I am trying to do is have an Excel Sheet with a set of values in Column A and
run a sql query using the values in column A to populate the corresponding cell on the same row in column B with an aggregrate value (MAX). Column B should contain the last active date for the part.

(Before SQL run)
Column A    Column B
part1            <null>
part2            <null>
part3            <null>


(After SQL run)

Column A    Column B
part1            2010-08-01
part2            2010-07-01
part3            2009-01-01

and so on

I am using Excel 2010, SQLSERVER 2008.

My procedure is as follows: On the ribbon select the DATA tab, then CONNECTIONS button, then select my procedure X from the WORKBOOK CONNECTION list, press the PROPERTIES button on the same screen. press the DEFINITION tab on the CONNECTION properties screen, change the COMMAND TYPE to 'sql' and type the
following in the COMMAND TEXT window .

select name 
from pbaTable
where
pbaid = ?????

I've tried many things where the ????? are but nothing works as far as reading
from the cell, absolute values do work, so the connection is good but that's not what I want.
Kevin