title: SQLite import csv using powershell
body: <p>I want to import a CSV File (comma delimited with double quote) into <code>sqlite3</code> within a PowerShell script. I tried:</p>
  
  <pre><code>echo ".import export.csv mytable" | sqlite3.exe
  </code></pre>
  
  <p>but I get this error:</p>
  
  <blockquote>
    <p>export.csv:327: unescaped " character</p>
    
    <p>327 > line number (i get this error for all lines)</p>
  </blockquote>
  
  <p>But on the command line when I use <code>sqlite3</code> shell and enter same command then it works:</p>
  
  <pre><code>sqlite &gt; .import export.csv mytable
  </code></pre>
  
  <p>How can I make the command work within a PowerShell script?</p>