title: Unable to import a csv into a table in SQLite: no such table error
body: <p>I have a wireshark dump in .csv format that I want to analyze. I tried importing the CSV file as described <a href="http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles" rel="nofollow">here</a>. These are the commands I ran from the command line-</p>
  
  <pre><code>sqlite&gt; create table network(no,time,source,dest,proto,info);
  sqlite&gt; .separator ",";
  sqlite&gt; .import E:\\Pavan\\_DataScience\\MP1\\network_data1\\challenge_network\\TestNetworkData.csv network;
  Error: no such table: network;
  sqlite&gt; .tables
  network
  sqlite&gt;
  </code></pre>
  
  <p>The <code>.table</code> command clearly shows that the <code>network</code> table is indeed present. I am not getting why the import command fails.</p>
  
  <p><strong>PS</strong>: I am running the sqlite3 executable downloaded from the <a href="http://www.sqlite.org/download.html" rel="nofollow">official site</a> on Windows.</p>