Displaying 1 result from an estimated 1 matches for "week_42".
Did you mean:
week42
2012 Nov 06
0
How to read all table in r using dbreadTable, autimatically read in whenever I save new table in SQLite db
...than typing "week42" "week33" in dbReadTable?
library(RSQLite)
library(sqldf)
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
dbListTables(con)
#dbRemoveTable(con, "week39")
dbDisconnect(con)
week42<- dbReadTable(con, "week_42")
week33<- dbReadTable(con, "week33")
week30<- dbReadTable(con, "week30")
Another one is if I save new table in sqlite db, I hope R programs can autimatically read in the new table, how can I achieve it?
Thanks.
Tammy
[[alternative HTML version delet...