Looping Through Text File Question

[alexanderjames]

Hi All

Just a question on capturing the data that i need from looping through a text file.
I need to find a couple of records and then store them into an access db,
so in my limited vb knowledge i have come up with this idea.

Dim N As Integer
Do While Not rs.EOF
For N = 0 To rs.Fields.Count - 1
    If rs.Fields(N).Value = "^CASH" Then
          Text2.Text = rs.Fields(N).Value '<<<< store in text box "CASH"
          Text3.Text = rs.Fields(N + 3).Value ' <<< store in text box "$25.00
          Exit For
    End If
Next N
rs.MoveNext
Loop

to store the data, found from the loop into text boxes and then update the database from the data in the textbox.
But i need to pick out about 40 records ie. "Credit Card", "Total Sales" etc and this would mean that i would need
alot of invisible text boxes, so my question is, is this the best way to achieve this or is there a better way.

Many thanks