Reading from DB to Array/Variable

C

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.
 
J

Jezebel

Dim MyArray() as [whatever]

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top