Displaying 1 result from an estimated 1 matches for "in_csv".
Did you mean:
in_c
2010 Nov 15
5
How to Read a Large CSV into a Database with R
...ot;)
sqldf("select * from ss09pusa limit 3",dbname="sqlite")
I've also tried using the SQL IMPORT command, which I couldn't get working
properly, even on a tiny two-field, five-row CSV file.
library(RSQLite)
setwd("R:\\American Community Survey\\Data\\2009")
in_csv <- file("test.csv")
out_db <- dbConnect(SQLite(), dbname="sqlite.db")
dbGetQuery(out_db , "create table test (hello integer, world text)")
dbGetQuery(out_db , "import in_csv test")
Any advice would be sincerely appreciated.
Thanks!
Anthony Damico
Ka...