This section describes the dependencies for using R with the CData ODBC Driver for Microsoft Excel Online.

Configure unixODBC (Linux and Mac Only)

RODBC uses unixODBC on Linux and Mac, so make sure your driver is configured as described in Using unixODBC before continuing.

Install RODBC

You can install the latest RODBC package from CRAN using install.packages.

install.packages("RODBC")

If you are interested in using parameterized queries, you should install RODBCext as well. RODBCext is an add-on library to RODBC that adds support for parameterized queries.

install.packages("RODBCext")

Using RODBC

To use RODBC, you must load the RODBC and RODBCext libraries.

library(RODBC)
library(RODBCext)