Loading query values into an array

[Rod]

Newby question: I want to load the complete results of a query into an array
using the GetRows method:

Set myArray = mySQL.GetRows(myNumrows)

In the simplest instance, mySQL = "SELECT * FROM MyTable".

How do I set mySQL and how do I set myNumrows to be the full recordset?

 

[Klatuu]

myArray = mySQL.GetRows(adGetRowsRest, adBookmarkFirst)

Will return all fields in the query for all rows. You don't need the word
Set.