easyrodbcaccess: Simple Database Interface for SQLite, MySQL and MS Access

Simple database interface for MS Access. easyrodbcaccess is build on top of RODBC. It provides functions for reading, writing, listing and subsetting tables in MS Access. easyrodbcaccess allow to retrieve, write and subset database's tables in a similar way as data.frame's, using single square brackets db[,,,]. easyrodbcaccess internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Author
Julien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication
2016-06-09 08:39:24
Maintainer
Julien MOEYS <Julien.Moeys@mark.slu.se>
License
AGPL-3
Version
0.7.8
URLs

View on R-Forge

Man pages

easyrodbcaccess-package
Simple Database Interface for SQLite, MySQL and MS Access
edbColnames.RODBC_Access
Retrieve column names of a table in a MS Access database...
edbDelete.RODBC_Access
Delete all or some rows in a table in a MS Access database...
edbDrop.RODBC_Access
Drop a table in a MS Access database (referenced by 'edb').
edbNames.RODBC_Access
Retrieve table names in a MS Access database (referenced by...
edbNRow.RODBC_Access
Retrieve the number of rows of a table in a database...
edbQuery.RODBC_Access
Send and retrieve a query in an MS Access database...
edbRead.RODBC_Access
Read all or part of a table in a MS Access database...
edbWrite.RODBC_Access
Write data in a MS Access table in a database (referenced by...
z[_-.RODBC_Access
"[<-" method for MS Access databases. Write data in a MS...
z[.RODBC_Access
"[]" method for reading all or part of a table in a MS Access...

Files in this package

easyrodbcaccess/DESCRIPTION
easyrodbcaccess/NAMESPACE
easyrodbcaccess/NEWS
easyrodbcaccess/R
easyrodbcaccess/R/easyrodbcaccess.R
easyrodbcaccess/R/onAttach.R
easyrodbcaccess/inst
easyrodbcaccess/inst/SVN_VERSION
easyrodbcaccess/inst/soils.accdb
easyrodbcaccess/inst/soils.mdb
easyrodbcaccess/inst/soils.original.mdb
easyrodbcaccess/man
easyrodbcaccess/man/easyrodbcaccess-package.Rd
easyrodbcaccess/man/edbColnames.RODBC_Access.Rd
easyrodbcaccess/man/edbDelete.RODBC_Access.Rd
easyrodbcaccess/man/edbDrop.RODBC_Access.Rd
easyrodbcaccess/man/edbNRow.RODBC_Access.Rd
easyrodbcaccess/man/edbNames.RODBC_Access.Rd
easyrodbcaccess/man/edbQuery.RODBC_Access.Rd
easyrodbcaccess/man/edbRead.RODBC_Access.Rd
easyrodbcaccess/man/edbWrite.RODBC_Access.Rd
easyrodbcaccess/man/z[.RODBC_Access.Rd
easyrodbcaccess/man/z[_-.RODBC_Access.Rd
easyrodbcaccess/tests
easyrodbcaccess/tests/edbColnames.RODBC_Access.R
easyrodbcaccess/tests/edbDelete.RODBC_Access.R
easyrodbcaccess/tests/edbDrop.RODBC_Access.R
easyrodbcaccess/tests/edbNames.RODBC_Access.R
easyrodbcaccess/tests/edbQuery.RODBC_Access.R
easyrodbcaccess/tests/edbRead.RODBC_Access.R
easyrodbcaccess/tests/edbWrite.RODBC_Access.R