I have a text file being created nightly in a network shared folder. That file has many lines including 3 duplicates. The line duplicated 3 times is:
ACCNT Accounts Receivable - MU OCASSET
What I need to do is, from within an Access function, delete the 2nd and 3rd dupe, leaving the first one intact.
Why the dupes exist is a rabbit hole that I don't right now have time to fix even though yes, that is the correct way to really fix this problem. But, if I can just have Access code which will delete the 2nd and 3rd entry of that line, it will suffice as a solution for now.
Thank you very much for any input.