I have a text file that has double carriage returns and need to clean these out before importing the file into Access 2002. These returns happen in the middle of a field not at the end of a line.
Is there a way through VBA to write a routine that will look at the .txt file and remove all instances of double carriage return?
Any help would be appreciated, the .txt file is too large to open and manually search.
Is there a way through VBA to write a routine that will look at the .txt file and remove all instances of double carriage return?
Any help would be appreciated, the .txt file is too large to open and manually search.
