Using ADO to Read and Parse a Text File - April 2002 Tip-Of-The-Month

[Larry Rebich]

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:

http://www.buygold.net/tips

then look for this month's tip.

Cheers,
Larry Rebich

[Michael Cole]

Larry,

Just a note to say that Robert Smith's site, www.smithvoice.com, is also
good for this sort of stuff. Direct link is
http://www.baristaware.com/sv/vbfun.htm



"Larry Rebich" <lrebich@earthlink.net> wrote in message
news:3ca931af@10.1.10.29...
> 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:
>
> http://www.buygold.net/tips
>
> then look for this month's tip.
>
> Cheers,
> Larry Rebich
>
>
>
>