ADO & Results Sets In Excel

[spence27]

Just a quick question to you most knowledgeable people

I know who to create a result set from a data source, and 99% of the time things work as they should, but what I would like to do is hit the data source once and then create a result set which I can then create additional smaller results sets from to populate ranges in excel.

Basically I only want top hit the data source once. Then load everything in to memory, and then use the returned result set separate from the data source to return data depending on SQL feed to it.

Can this be done, and if so how?

All help greatly appreciated

Thanks#Spence

 

[JerryKlmns]

Filtering could be of use?

 

[spence27]

Thanks for the reply but could you give me a little bit more infomation i.e. what is filtering (in this context) and how would i use it.

I have been doing a little bit more leg work since i posted originaly and have found it is posible to create disconected recordset, which would give me the fist part of my requrements i.e. Hit the data source one create a result set and drop the connection.

I suppose what i need to know next is how to throgh some SQL against a existing result set? - Any Ideas ?

 

[JerryKlmns]

SQL expects to find tables or queries not recordsets.

Dir rst As ADODB.Recordset
...
rst.Open
...
rst.Filter "FilteringFieldName = " & txtFilter

Place cursor on Filter keyword and press F1 to get detail explaination