Very Computer

Ok, heres the deal...
I have a text file, and it is separated into fields by the symbol ~. All
I want to do is get a VB DB program to read in this file, and put the
data into a table for use by separating the fields by the ~. Its like
bringing in the file to Excel, and picking separated by ~ selector. But,
I want my program to do this automaticially, so I can proceed to desgin a
database built on this. Please email or post any help. A snipit of code
would be nice :)

--
***************************************************************************
*                        Darren VanWageningen                             *
*                                                                         *

*                                                                         *
*               http://www.tuns.ca/~dvanwage/eternal.html           *
*                                                                         *
*                  FSP: newton.ccs.tuns.ca Port 4303                      *
***************************************************************************

   Open TextFile For Input As #1
   Line Input #1, Txt

   ' Load array  Tagrec with Individual Elements
   For I = 0 To NumFields
      J = InStr(1, Txt, "~")       ' Find 1st/Next Delimiter
      If J = 0 Then Exit For       ' All Done
      Tagrec(I) = Left(Txt, J - 1) ' Move Element to Array
      Slen = Len(Txt)              ' Length of String
      Txt = Right$(Txt, Slen - J)  ' Remove Leftmost Element
   Next I
   Tagrec(I) = Txt                 ' Last Element

Hope this is of help