Greetings all. Its been some years since I did anything in QB.
I need to manipulate a txt file so it can be imported into MSAccess.
The file is already comma delimitted, however each line of text contains multiple records.
I need to insert a <return> after every 35 commas (fields), before I can import the data into MSAccess.
The txt file is rather large (>20 megs) and manually inserting a <return> when needed is not an option.
Any assistance is appreciated!