Reading from DB to Array/Variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cash - 30 Oct 2006 23:00 GMT

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.

Reply to this Message

Jezebel - 30 Oct 2006 23:33 GMT

Dim MyArray() as [whatever]

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

> I'll better start by informing that I'm newbie into DB v/s VB.
>
[quoted text clipped - 7 lines]
>
> Thanx.

Reply to this Message