OLE DB Query Using Cell Value as Variable

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

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.
 
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.
Click to expand...

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Range Copy... 13
Trying to run excel vba code when cell value changes from empty to entered value. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA: How can I use a string variable as autofilter criteria? 4
Macro storing as a date? 11
adding 1 to previous cell value using code 2
If cell value is greater than another cell value, clear contents. 6
Does variable set to cell value automatically becomre cell value? 2

Back
Top