Package: kwb.db 0.7.0

Hauke Sonnenberg

kwb.db: Functions supporting data base access

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.

Authors:Hauke Sonnenberg [aut, cre], Michael Rustler [ctb], Kompetenzzentrum Wasser Berlin gGmbH [cph]

kwb.db_0.7.0.tar.gz
kwb.db_0.7.0.zip(r-4.5)kwb.db_0.7.0.zip(r-4.4)kwb.db_0.7.0.zip(r-4.3)
kwb.db_0.7.0.tgz(r-4.4-any)kwb.db_0.7.0.tgz(r-4.3-any)
kwb.db_0.7.0.tar.gz(r-4.5-noble)kwb.db_0.7.0.tar.gz(r-4.4-noble)
kwb.db_0.7.0.tgz(r-4.4-emscripten)kwb.db_0.7.0.tgz(r-4.3-emscripten)
kwb.db.pdf |kwb.db.html✨
kwb.db/json (API)
NEWS

Peer review:

Bug tracker:https://github.com/kwb-r/kwb.db/issues

On CRAN:

data-importdatabase-accessdatabase-connectionrodbc

55 exports 3.38 score 6 dependencies 22 dependents 5 scripts

Last updated 12 months agofrom:d4b0d9b2a9. Checks:OK: 3 NOTE: 4. Indexed: yes.

Exports:createRDatabaseInterfacecurrentDbdataFrameToSqlTuplesdumpDatabasegetCurrentSqlDialectgetDatabaseFieldInfogetNamedExcelRangeshsClearTablehsCloseMdbhsDropTablehsFieldshsGetTablehsGetTimeSerieshsLookupOrAddRecordhsMdbTimeSerieshsOpenDbhsPutTablehsSetForeignKeyhsSetPrimaryKeyhsSqlExAndhsSqlExOrhsSqlExTimeCondhsSqlExTimeGrouphsSqlExTsFieldshsSqlQueryhsTablesisExcel2003FileisExcel2007FileisExcelFileisMySQLkeyValuesToSqlkeyValuesToSqlAssignmentkeyValuesToSqlAssignment2keyValueToSqllistValuesToSqllookupRecordmerge_relationsread_relationsread_schematarenamesToFieldListrenamesToQueriesselectFromTablesetCurrentDbsetCurrentSqlDialectsqlForInsertsqlForInsertDataFramesqlForInsertFromSelectsqlForInsertIgnoreInMsAccesssqlForSelectsqlForSelectByKeysqlForUpdatesqlFullLeftJoinsqlJoinExpressionsqlLeftJoinExpressionxmdb

Dependencies:kwb.datetimekwb.utilsodbc32pbdZMQr2rRODBC