Q:

R Import Multiple Tables from database using sqlQuery

I know how to import a table from the database, it works; but what if I have 6 tables, is there a better way to import from 6 different tables and create 6 different data.frames ?
Notes <- sqlQuery(dbConnection, "
                      SELECT *
                      FROM
                      Table1")
??

A:

Consider an lapply call across a list of tables:
tableList <- c("Table1","Table2","Table3","Table4","Table5","Table6")

# BUILD LIST OF DFS FROM QUERIES
dfList <- lapply(tableList, function(t) sqlQuery(dbConnection, paste0("SELECT * FROM ",  t))

# NAME EACH ELEMENT TO CORRESPONDIND TABLE NAME
dfList <- setNames(dfList, tableList)

And then if you want separate dataframes use list2env but you can always work directly from dfList to avoid many objects in global environment:
list2env(dfList, envir=.GlobalEnv)

