vik-y
10/25/2016 - 5:44 AM

Use sqlite table in R

Use sqlite table in R

sql-connect.r
content_copyfile_download
library("RSQLite")
# connect to the sqlite file
driver <- dbDriver("SQLite")
con = dbConnect(driver, dbname="<absolute-path-to-sqlite-file>")

# get a list of all tables
alltables = dbListTables(con)