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:
- The mainly internal odbc* functions: 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 Read more Import data from Excel into R using RODBC package