| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varioable in SQL statement
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Varioable in SQL statement
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Varioable in SQL statement
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Varioable in SQL statement
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Varioable in SQL statement
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
