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?