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