R/read.access.R

In SwampThingPaul/AnalystHelper: Helper functions developed over the years to extract and format data

#' Data retrievial from South Florida Water Management District online database (DBHYDRO)
#'
#' @param channel The path to the access (.accdb) files with extension
#' @param table Table within databases. If unsure check RODBC::sqlTables()
#' @keywords access
#' @export
#' @return This function allows for quick access of data within an 2007/2010 Microsoft Access database (.accdb).
#' @examples
#'\dontrun{
#' dat=read.access("/database.accdb","WaterQuality")
#'}


read.access=function(channel,table){
  chan=RODBC::odbcConnectAccess2007(channel)
  dat=RODBC::sqlFetch(chan,table)
  close(chan)
  return(dat)
}