RODBC-package: ODBC Database Connectivity

Description Details Author(s)


Package RODBC implements ODBC database connectivity.

See the package manual for details of installation and use. (This will show up as a vignette, and can be accessed via RShowDoc("RODBC", package="RODBC").)


Two groups of functions are provided. The mainly internal odbc* commands implement low-level access to the ODBC functions of similar name. The sql* functions operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables. Many connections can be open at once to any combination of DSN/hosts.


Michael Lapsley and Brian Ripley

Search within the RODBC package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.