If the delimited text file needs to be accessed alot and you will continue to use the program to do it, create a data-aware class. It is a bit of work, but once you set it up, you then access the text file as if it is a database and can use the ADO methods on it.
In VB help, search for the following article:
Creating a Data-Aware Class that Reads Records from a Delimited Text File
It leads you step by step. You may not understand all of the steps at first, but include them if they are in the sample code. I have done this and it works fantastic.




Reply With Quote