Is there a way to have Access modify CSV files through ISAM?

[Guest]

I want to use CSV files to allow access to the legacy
system can I just link to the file and use ISAM to write
to the CSV file? I complains it can't update with the
installed ISAM driver. I was hoping that a ISAM driver is
a available that does this.

 

[John Nurick]

CSV files are hard to modify because every time you change the length of
a single field the system has to rewrite the entire remainder of the
file. With big files in a multiuser environment this is impractical, and
Access doesn't attempt it.

The best approaches are either
- import, modify, export back to CSV
- use textfile tools such as Perl, Textpad or whatever.