title: Open an ANSI csv file and read the content as utf-8
body: <p>I have a csv file on the server encoded as ANSI, and want to open it, process and save the content on the database.
  I'm having infinite problems with the accented character as "à è ì ò ù", getting instead "?".</p>
  
  <p>The content in the html header is set as utf-8.
  This is my code</p>
  
  <pre><code>Response.CharSet = "UTF-8"
  
  ...
  
  Set objStream = CreateObject("ADODB.Stream")
  objStream.Type = 2
  objStream.CharSet = "utf-8"
  objStream.Open
  objStream.Position = 0
  objStream.LoadFromFile( path )
  
  strData = objStream.ReadText()
  Response.write(strData) '&lt;== just to see
  
  objStream.Close
  Set objStream = Nothing
  </code></pre>
  
  <p>At first I was using a single FileSystem object, but read that it has even more problems handling encoding</p>