Thanks UglyChicken - Not for Access, this is for SQL Server. I tried your
suggestions and got same error message - "invalid column name"

"UglyChicken" wrote:

On Nov 11, 10:39 am, JimBob wrote:
All - I am trying to pass a variable to a SQL select statement using ADO data
connection, but keep getting error message back indicating "invalid column
name" - and it referw to teh VALUE of the variable I am passing.

A user selects a value from a drop down list in an Excel workbook (Cell
$C$1). I use that value to pass to to teh SQL query:

"Select * from Table1 where ClientName=" & range("C1").value

Any suggestions on how I maye be able to embed a variable into a SQL query?

You need to put quotes around the range value something like
"SELECT * FROM Table1 WHERE ClientName= " & Chr(34) &
range("C1").value & Chr(34) & ";"

This is for Microsoft Access?