I use the following code to open a super large text file
so I can rewrite it to a smaller size for import.
This code works great.
Now I have another even larger text file that I need data from
I have determined that if I can say something like
(only grab the records where col 92-93-94-95 = 2014)
and write it to file 2 then I can narrow it down to the records I need
is this possible?
'this converts the large file to an Access importable file
Open "C:\ERPDP\NationsIn\LISLEPD\EFTOFS5617MONMEMDD150201T1620042.txt" For Input As #1
Open "C:\ERPDP\MONMEMD.txt" For Output As #2
Do Until EOF(1)
Line Input #1, str
If str & "" <> "" Then _
Print #2, Left(str, 406)