View Single Post
  #1   Report Post  
BD
 
Posts: n/a
Default Import from Database using field from excel.

I would like to update a cell in Excel with a date and
then somehow have the Excel document import data
from an outside SQL database with the new date. I can
hardcode the date in the database lookup(& it works now)
but I would like to instead have it refer to cell on the page.
Is this a possibility ?

Thanks,
BD

PS. One more quick question... is there a way to execute a
stored procedure against a SQL Database and get the records
from that query ? (I can work around this one... created views)
Mostly wondering for future projects.