Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE DB Query Using Cell Value as Variable
Is it possible to use a cell value in my query? My Command Text is
EXEC sp_get_excel and I'd like to add a date to that by entering it in an empty cell. Thanks. -- Jerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE DB Query Using Cell Value as Variable
On Mon, 24 Mar 2008 12:13:14 -0700 (PDT), Jerry wrote:
Is it possible to use a cell value in my query? My Command Text is EXEC sp_get_excel and I'd like to add a date to that by entering it in an empty cell. Jerry: I'm not familiar with that syntax in CommandText. Is that running a stored procedure? What database is on the back end? Could you use SQL syntax instead of a stored procedure? -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADO SQL syntax query, using a variable | Excel Programming | |||
Deleting variable web query name | Excel Programming | |||
With QUERY how to input a variable | Excel Discussion (Misc queries) | |||
put query result into variable | Excel Programming | |||
Query that returns a value to variable | Excel Programming |