ODBC and R

[mikerspencer]

I suggest replacing the R/SQL code with the following:

library("RSQLite")
dbfile = "C:/Users/pfsmy/OneDrive/UoM/Carpentry/Datasets/SN7577.sqlite"
mydb = dbConnect(drv = SQLite(), dbname=dbfile)
results = dbGetQuery(mydb, "SELECT * FROM SN7577")
dbDisconnect(mydb)

Using dbGetQuery is more straightforward and makes the code easier to read.

[henrykironde]

Thanks @mikerspencer, related issue in swcarpentry/sql-novice-survey#331