Quote Originally Posted by andycl View Post
With word wrap off, the middle of the third line is where the last header name is and the data starts. This particular file has over 200 field names. But it is not one continuous line even with word wrap off. With word wrap on its many more lines. I'm going to put the files up here. Because even with the db OBP posted the append routine does nothing when I added reccount. It doesn't move any of the data to the master file. That makes no sense.
That means that even the Records are probably spread across multiple lines.

I think that the files must be read by field count, rather than by lines.

Something like 
'first, Replace linefeeds with separator
TmpArray = Split(FileText, Separator)

For j = 0 to UBound(TmpArray) Step FieldCount
If TmpArray(j) = FirstHeaderName then GoTo J_Next 'Skips Headers
Write(TmpArray(j to j+FieldCount) to TmpFile
Write Linefeed Character toTmpFile
J_Next:
Next

Append TmpFile to Master