The The R Primer logo Primer

Read data from an SQL database using ODBC

Import data from an application that supports Open DataBase Connectivity.

Solution: Use the RODBC package to import data from databases. This can be used for importing data from databases or from spreadsheets supporting ODBC like Microsoft windows.

See rule 1.4 in The R Primer for more information.

Back to tips.