title: Export CSV without col.names
body: <p>I need to take a <code>data.frame</code> and export it to a CSV file (or something else, but CSV seemed like the easiest well-formed format) so I can import it into an SQLite database.</p>
  
  <p>However, it looks like <code>write.csv()</code> requires that I write a header line, and SQLite's <code>.import</code> command requires that I <strong>don't</strong> have a header line.  So that's a bit of a mismatch.</p>
  
  <p>Here's what happens if I try to omit the header line:</p>
  
  <pre><code>&gt; write.csv(mydf, "/tmp/mydf.csv", row.names=F, col.names=F)
  Warning message:
  In write.csv(mydf, "/tmp/mydf.csv", row.names = F, col.names = F) :
    attempt to set 'col.names' ignored
  </code></pre>
  
  <p>I have to wonder why it's enforcing that in the first place - the manual says <em>"These wrappers are deliberately inflexible: they are designed to ensure that the correct conventions are used to write a valid file. Attempts to change <code>append</code>, <code>col.names</code>, <code>sep</code>, <code>dec</code> or <code>qmethod</code> are ignored, with a warning."</em>  But I know of nothing in the spec or elsewhere requiring column names - indeed, most tools (Excel, etc.) don't treat them specially.</p>