title: Read large file line-by-line with ADO Stream?
body: <p>I want to use ADO Stream to read lines from a local large text file with UTF-8 encoding so I try</p>
  
  <pre><code>Set objStream = CreateObject("ADODB.Stream")
  objStream.Charset = "utf-8"
  objStream.Type = 2
  objStream.Open
  objStream.LoadFromFile = strFile
  objStream.LineSeparator = 10
  Do Until objStream.EOS
      strLine = objStream.ReadText(-2)
  Loop
  </code></pre>
  
  <p>However the result is that the script takes lots of RAM and CPU usages. So is there any way to tell the script not to load all the file contents into memory, but just open it and read until it encounters any line separator?</p>