View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default Append text file

How about something like this.
fNum=FreeFile
Open TextFileA For Append As fNum
Print fNum, TextFileB
Close fNum

Jeff wrote:
Hi,

I have two text files and I want to append TextFileB onto the end of TextFileA

TextFileA is 3 million rows
TextFileB is 100 rows

The problem is that TextFileA is 3 million rows long. So I do not want to
create an array, load all of TextFileA, then output TextFileA and then the
100 lines of TextFileB (that would take a long time). That is the only way I
know of to append B to the end of A.

Can anyone help?

Thanks!