Writing SQL Queries Against Virtual Tables in Excel VBA

[robnjay]

Nate:

I am an old-timer with VB, although very rusty now. In fact, I was very flattered to find my name mentioned in Mr. McKinney's book you reference above. I've written some very involved VBA in Excel, several add-ins, but I am really lost with regard to ADO & database queries, etc.

My problem is this: I want to be able to write a query (join) to two tables: One with "TimeStamps" and "Values" from a process database ("DRIVER={AspenTech SQLplus} and one with "RequestedTimeStamps" from either a range of cells in the ActiveWorkbook, or from a Variant Array created in VB. The results of the join (2 fields - "TimeStamp" and "Value") will be put in a column on the same workbook (Value field only).

I don't care what db driver I use for the table of "Requested Dates" or the resulting table ("ReconciledTimeStamps&Values"). I just don't want to have to carry around an mdb file or write to a temporary range in the open workbook.

I thought if I could create recordsets with (1) process values and (2) requested timestamps, I could then write a query against these recordsets to create the third - "reconciled..". I don't know enough about this whole business to understand whether this is even possible.

BTW, I am able to create the (1) and (2) recordsets...

Thanks for your help
Rob