一些示例代码将整个数据存储在data.frames中：

library("Rsqlite")

## connect to db
con <- dbConnect(drv=Rsqlite::sqlite(),dbname="YOURsqlITEFILE")

## list all tables
tables <- dbListTables(con)

## exclude sqlite_sequence (contains table information)
tables <- tables[tables != "sqlite_sequence"]

lDataFrames <- vector("list",length=length(tables))

## create a data.frame for each table
for (i in seq(along=tables)) {
  lDataFrames[[i]] <- dbGetQuery(conn=con,statement=paste("SELECT * FROM '",tables[[i]],"'",sep=""))
}