This month's tip shows how to use ADO to read and parse a text file. From
the tip's intro:

ADO [Active Data Objects] can be used to read a variety of file formats. I
have used it to read and parse a CSV or fixed width format text file. ADO
reads and parses the file into a recordset. When I first needed to parse a
text file I tried various routines - some provided via other users - and
none seemed satisfactory. So I did some research and discovered that ADO
will perform the task. I've revisited the code, wrote a demo program and
made this the April 2002 tip-of-the-month.

To view the tip, link to:

then look for this month's tip.

Larry Rebich