DESCRIPTION

Package: kwb.db
Title: Functions supporting data base access
Version: 0.7.0
Authors@R: 
    c(person(given = "Hauke",
             family = "Sonnenberg",
             role = c("aut", "cre"),
             email = "hauke.sonnenberg@kompetenz-wasser.de",
             comment = c(ORCID = "0000-0001-9134-2871")),
      person(given = "Michael",
             family = "Rustler",
             role = "ctb",
             email = "michael.rustler@kompetenz-wasser.de",
             comment = "0000-0003-0647-7726"),
      person(given = "Kompetenzzentrum Wasser Berlin gGmbH",
             role = "cph"))
Description: This package contains some useful functions, especially for
    simplifying data transfer between MS Access databases and R. With the
    functions of this package it is not needed any more to open and close
    a database connection explicitely; this is done 'behind the scenes' in
    the functions. Instead of a database connection the path to the
    database file needs to be passed to the functions as an argument. The
    main functions are hsGetTable and hsPutTable which transfer data from
    an MS Access database to a data frame in R and save data from a data
    frame in R into a table in an MS Access database, respectively. Take
    care when getting time series data from an MS Access database, see
    therefore hsMdbTimeSeries. Use hsTables to get a list of tables that
    are available in a database and hsFields to get a list of table fields
    that are contained in a database table.
License: MIT + file LICENSE
URL: https://github.com/KWB-R/kwb.db
BugReports: https://github.com/KWB-R/kwb.db/issues
Imports:
    kwb.datetime (>= 0.4.0),
    kwb.utils (>= 0.4.4),
    odbc32 (>= 0.2.7),
    RODBC (>= 1.3.16)
Suggests: 
    testthat (>= 2.2.1),
    xml2
Remotes: 
    github::cran/RODBC@1.3-16,
    github::hsonne/odbc32@r3.0.0,
    github::kwb-r/kwb.datetime,
    github::kwb-r/kwb.utils
Encoding: UTF-8
RoxygenNote: 7.2.3