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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top