Loading query values into an array

  • Thread starter Thread starter Rod
  • Start date Start date
R

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?
 
myArray = mySQL.GetRows(adGetRowsRest, adBookmarkFirst)

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