Luv the UglyChicken - single quote worked great !

"UglyChicken" wrote:

On Nov 11, 11:06 am, JimBob wrote:
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?- Hide quoted text -

- Show quoted text -

SQL server uses single quotes ie. Chr(39) replace the Chr(34) with it.
If you still have the same problem then double-check the spelling of
the field name ClientName and that it is definitely a field in table1