title: Using VB.Net to import my CSV file to my Access DB
body: <p>I am using the below code to import a CSV file to my Access DB.  I just have a couple of questions.</p>
  
  <pre><code>    Con.Open()
      Dim strSqlCommand = "SELECT F1 AS id, F2 AS firstname " &amp;
                          "INTO MyNewTable " &amp;
                          "FROM [Text;FMT=Delimited;HDR=No;CharacterSet=850;DATABASE=" &amp; GlobalVariables.strDefaultDownloadPath &amp; "].Airports.csv;"
      Dim sqlCommand = New System.Data.OleDb.OleDbCommand(strSqlCommand, Con)
      sqlCommand.ExecuteNonQuery()
      Con.Close()
  </code></pre>
  
  <p>How can I change the Character Set to UTF-8?  If I enter utf8 instead of 850 I get an error.</p>
  
  <p>Also, the first line of my CSV file contains the column names.  Can I amend the above code to take that in to account?</p>
  
  <p>Regards,</p>
  
  <p>Andrew</p>