title: How to import tab delimited data to sqlite using RSQLite?
body: <p>I'd like to import a bunch of large text files to a SQLite db using RSQLite. If my data were comma delimited, I'd do this:</p>
  
  <pre><code>library(DBI)
  library(RSQLite)
  db &lt;- dbConnect(SQLite(), dbname = 'my_db.sqlite')
  dbWriteTable(conn=db, name='my_table', value='my_file.csv')
  </code></pre>
  
  <p>But how about with '\t' -delimited data? I know I could read the data into an R data.frame and then create the table from that, but I'd like to go straight into SQLite, since there are lots of large files. When I try the above with my data, I get one single character field.</p>
  
  <p>Is there a sep='\t' sort of option I can use? I tried just adding sep='\t', like this:</p>
  
  <pre><code>dbWriteTable(conn=db, name='my_table', value='my_file.csv', sep='\t')
  </code></pre>
  
  <p>EDIT: And in fact that works great, but a flaw in the file I was working with was producing an error. Also good to add header=TRUE, if you have headers as I do.</p>