How to store query data into dynamic array?

Originally Posted by CK76

Recordset is an array, and more versatile than VBA array. For an example, you can reference by column index or name.

If you want to minimize duration of connection being open. Then you could...

Dim ar
ar = CVRs.GetRows

Oh, thanks for the information. For GetRows , I assume ar is multiple dimensional array. Since I need further process the data, how can I refer to specific fields (Field1, Field2, Field3) within the array?

Let us say, I want to break it down to 3 small arrays for each field: ar1, ar2, ar3 . That being said ar(0) = ar1(0)+ ar2(0) + ar3(0); ar(1) = ar1(1)+ ar2(1) + ar3(1); .....

How to print array into sheet? For example, how to copy/paste ar to sheets("Test").Cells(1,1)?

Thanks.