Retrieving 2 or more values from a DB query

[egun]

Hi Basanth,

When I tried this:

Code:

adj = Split(val2, VBLF)

For i = Lbound(adj) to Ubound(adj)
msgbox adj(i)
Next

All that prints out is the same as before:
TRAIN1
TRAIN2

How can I go through the array (read about the LBound and UBound function) and assign each element to a new value? So that TRAIN1 and TRAIN2 are stored in 2 separate variables.

Thank you.