vendredi 21 août 2015

RSQLite not recognizing objects/ not writing tables

Here is my code, it should be straight forward enough and worked multiple times yesterday but it hasn't worked for me at all today.

> library(sqldf)
Loading required package: gsubfn
Loading required package: proto
Loading required package: RSQLite
Loading required package: DBI
db<-dbConnect(SQLite(), dbname="testing.sqlite")
dbWriteTable(db, "test", "mtcars")

Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") : cannot open file 'mtcars': No such file or directory

How can I get R to find Objects for this command? I checked my connection and I can read tables I just cannot write them.

Aucun commentaire:

Enregistrer un commentaire