SQL Query Results placed in an Array

[LJA520]

Hello,

Is there a function that will take the results of an sql query and load it directly into an array? without having to loop through the results?

Thank you so much!!

LJA

 

[PHV]

Both DAO and ADODB Recordset expose the GetRows method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[LJA520]

Perfect Thanks!!