Description Usage Arguments Value Author(s) Examples
View source: R/utility_functions.R
collect_tables
uses the RODBC
package to connect
to the UWIN database and collect the requested tables.
Note: For this function to work the Microsoft Access Database Engine must be installed. It can be found here.
1 | collect_tables(database = NULL, tables = NULL)
|
database |
File name of the UWIN Access database as a character vector.
If |
tables |
A character vector of the table names to be pulled from the
UWIN database. If this argument is left blank then |
A named list of tables from the UWIN database. Each table will be
returned as a data.table
instead of a
data.frame
, as this considerably speeds up
summarizing these data.
Mason Fidino
1 2 | # not run: dat <- collect_tables("UWIN_DB_CHIL.accdb")
# not run: dat <- collect_tables("UWIN_DB_CHIL.accdb", tables = c("Photos", "Visits"))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.