| 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? |
| 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 | |||
Threaded Mode
