If the file is in a delimited format, then you can use the ISAM Text driver to build a connection to the text file, and then either use an action query to update the file, or use a recordset object. With the latter, you would either set the criteria when opening the rs, or use the FIND/FILTER methods once the recordset is opened.
This method has been around a long, long time, and I have used it successfully. There are many threads concerning the subject. I have always found it best to use a Schema.INI to define what the text file structure is. This prevents errors when using it internationally, or when the format is different from the standard formats set in the Windows registry.
If you can, use DAO 3.51. It is most efficient with TEXT files, or any ISAM format.
The next best choice is DAO 3.6.
Then comes ADO.
Here are a few threads to get you started:
thread222-371928 thread709-334828 thread222-378000
However, there is another method, which is under ADO, which may be more effective if you want to build a recordset instead of using an action query, I have used this also for certain circumstances and it is also fast: Using a recordset object not coonected to a data source, but built from scratch (easier than what it sounds) and then using the traditional file OPEN to loop through the records and add them to the recordset.
You will find a recent discussion on the speed and different methods under this: thread222-381120
Of course, this thread also points out that if you do not need a recordset object, just using the traditional method for your purpose is probably the fastest. [/b][/i][/u]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
