Import Data From SQL Server Into R Using RODBC Package

This tutorial talks about how to import data from SQL server to R using RODBC package.

The functions provided by the RODBC package can be categorized into two groups:

  1. The mainly internal odbc* functions implement low-level access to the ODBC functions of similar name.
  2. The sql* functions operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables

Read more Import Data From SQL Server Into R Using RODBC Package

Import data from Excel into R using RODBC package

This tutorial talks about how to import data from Excel into R using the RODBC package.

The R’s RODBC package is generally used to import data from SQL database into R. However, this package can also be used to import data from Excel into R.

The functions provided in the RODBC package can be categorized into two groups:

  1. The mainly internal odbc* functions:  implement low-level access to the ODBC functions of similar name.
  2. The sql* functions: operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables Read more Import data from Excel into R using RODBC package