ADODB.recordset til array

Not quiet sure I understand the problem!

Lets say we have a table named tbl1 with two fields fld1 and fld2
In the table we have two records with the following data

fld1, fld2
1    2
10    20

If I now create a recordset with the following SQL

SELECT fld1, fld2 from tbl1

Now read the recordset into an array named aTbl1Values

aTbl1Values = RS.GetRows()

Now loop through "rows" in array

Dim iRowLoop

For iRowLoop = 0 To UBound(aTable1Values, 2)
            Debug.Print aTable1Values(0, iRowLoop) & ", " & aTable1Values(1, iRowLoop); ", " & aTable1Values(2, iRowLoop)

         
    Next 'iRowLoop

THis will result in

1, 2
10, 20

Oops little error there!

For iRowLoop = 0 To UBound(aTbl1Values, 2)
            Debug.Print aTbl1Values(0, iRowLoop) & ", " & aTbl1Values(1, iRowLoop); ", " & aTbl1Values(2, iRowLoop)

         
    Next 'iRowLoop

status koppelgaard?

Jeg er ked af at jeg ikke har svaret. Jeg har haft mega travt!!

Det ser helt rigtig ud, hvad du har lavet.
Tak for hjælpen!

Jeg vil gerne give pointene.

Kan du sende et svar?

Koppelgaaard

thanks