Editing Text DBs with ADO

I'm looking to work with a CSV file with ADO. Currently I can open the file and read through the records, as well as add new records. I cannot, however, edit or delete existing records.

Is this simply a limitation of working with a CSV file as opposed to a "true" DB file? We needed to keep this file in text format for reading by another process. I did import it into an mdb file and I was able to edit and delete records, so I am afraid that it really is a limitation.

Any thoughts?


QuaffAPint

VB6SP3

[Clunietp]

This seems to be a limitation of the driver. The Jet provider also supports a variety of other formats (DBase, Text, Lotus, Excel, etc) and they all have varying levels of support for editing, deleting, etc. (most of them are read-only)

If you don't want to load the data into an intermediary Access DB, you might have to bypass using ADO alltogether and use VBs OPEN and LINE INPUT statements to get your data, and then use the SPLIT function to parse the fields. Then you can edit it and put it back into the file

Good luck