Want to use Excel2010 cell column as driver for SQL Server 2008 query

Question

It's hard to believe I'm the only one, but .. I want to use the Connection functionality in Excel to connect to a SQL Server database and populate column X based on using the value in column Excel A as the primary key, but I could not figure out how to do this.

I tried (by typing a command text box)

select name 
from pbaTable
where
pbaid = (and this is where I'm stuck)

Answer 1

It's time to find it too!

step 1: put the question mark in the command text

select name 
from pbaTable
where
pbaid = ?

2: , , - -.

3: (.. //). -

4: " " .

4: , , . = ! $J $1

Answer 2

Excel col A, SQL Server pbaTable col pbaid , , SQL Server pbaTable Excel.

where, - .