Install RSQLite with, e.g. install.packages("RSQLite", depends = TRUE) (pick a repository from the list that is close to you.)
con <- dbConnect(dbDriver("SQLite"), "~/baseball2.db")
dbListTables(con)
x = dbGetQuery(con, ""SELECT DISTINCT yearID from Teams")

Duncan Temple Lang <duncan@wald.ucdavis.edu>
Last modified: Tue Jul 15 09:32:28 PDT 2008