Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
db query with dynamic criteria
I need to be able to run a query from a cell to pull in 1 bit of data for a
particular date. I would like to be able to just call a funciton if possible and pass it the date: =GetData(A12) In return I would get data from the Access database. I can't seem to find any info on any of it except to populate a spreadsheet with all of the data returned, but I only need one record and really only one field from that record. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
db query with dynamic criteria
Not sure if it is the best way but I went back to just using ADODB and a
recordset. It works and works quickly. -Stanley "Stanley" wrote: I need to be able to run a query from a cell to pull in 1 bit of data for a particular date. I would like to be able to just call a funciton if possible and pass it the date: =GetData(A12) In return I would get data from the Access database. I can't seem to find any info on any of it except to populate a spreadsheet with all of the data returned, but I only need one record and really only one field from that record. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria using "Or" and parameter query | Excel Discussion (Misc queries) | |||
query criteria question | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) |