-----Original Message-----
Hi Johan,
It doesn't work because the functionality hasn't been implemented,
because it would be very slow and complicated: in a delimited file,
whenever you add or remove a single character in any field, the position
of every character after that point changes, and with Windows (and most
other) file systems that means the entire file has to be rewritten.
Instead, just import the textfile to an Access table, update it, and
export to a new textfile. Or if the changes you need to make could be
done with an update query if the linked table was updatable, you can use
a make-table query. This obviously needs to return all the fields and
records you want, with the necessary updates. Use the SELECT ... INTO
.... IN ... syntax to export the results of this query to a new textfile.
I want to update linked txt-files with both Access and
another software. Does not work though...or?
Sincerely
Johan
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
