Reading from DB to Array/Variable

[Cash]

I'll better start by informing that I'm newbie into DB v/s VB.

What I need to do is to read from a different tables in a Access-DB and copy
the information into an array or an varibale. For each table there is one
array.

Could someone please instruct me, with example, on how to do it.
Would appreciate an example.

Thanx.

 

[Jezebel]

Dim MyArray() as [whatever]

:
Redim MyArray(1 to MyTable.RecordCount)
For pIndex = 1 to MyTable.RecordCount
MyArray(pIndex) = MyTable.Fields(...)
MyTable.MoveNext
Next
: