Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
import web table to excel | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |