I wish to use the results of a querytable update in the local worksheet as
the basis for loading up / populating a VBA Recordset WITHOUT needing to
re-hit the database for the information.

I am taking this approach so as to retain visibilty of the raw data and have
it on hand, in entirety, to mannually inspect / analyse if my automated logic
and integrity checks in VBA highlight that there is a need to delve deeper
into the integrity of the data.

There is likely to be great amounts of data in a real-time warehousing
environment so I want to avoid placing extra loads on the database / bandwith.

Here's what I've tried and been stumped at :

The vba refresh :

Worksheets("qryInventoryData").QueryTables(1).Refr esh BackgroundQuery:=False

And here's the failing attempt to populate the VBA recordset :

Set rsData = Worksheets("qryInventoryData").QueryTables(1).Reco rdset

Does anyone think this iss too much to expect ? Is there another way to
skin tis cat ?

Aaron