Configure Eclipse IDE to work for both 32-bit and 64-bit R

Sometime we need to make Eclipse compatible simultaneously for both 32-bit and 64-bit versions of R. For example, we may have the 64-bit R as the default configuration. However, if we want to run the odbcConnectExcel function which only works under 32-bit scenary, we have to switch the current active configuration to 32-bit R. This tutorial...

Read More

Use Eclipse as IDE for R under Windows

Background Eclipse is an open source Integrated Development Environment (IDE). As with Microsoft's Visual Studio product, Eclipse is programming language-agnostic and supports any language having a suitable plugin for the IDE platform. For Eclipse, the R language plugin is StatET. The StatET plugin enables Eclipse to connect to R. You...

Read More

Import date from Excel spreadsheet into R using RODBC package

Package RODBC can be used not only for ODBC database connectivity, but also for importing Excel spreadsheet data into R, as shown in following R code: library(RODBC) data=odbcConnectExcel(file.choose()) mydata=sqlFetch(data,"Sheet1") odbcClose(data) mydata Here, the odbcConnectExcel establishes a connection to an external Excel spreadsheet. Note: Function 'odbcConnectExcel' is only usable with 32-bit R. Under Eclipse...

Read More

Import data from Microsoft SQL server to R using RODBC package

As preparation, first create an ODBC driver connection for SQL Server by Control Panel >> Administrative Tools >> Data Sources (ODBC) Then import data from SQL server with following R code library(RODBC) conn <- odbcConnect(dsn="ACCPAC 54 SQL",uid="my_ID",pwd="my_PWD") #sqlTables(channel) queryResult <- sqlQuery(conn,...

Read More

Import data from Microsoft SQL server to R using RJDBC package

Environment Windows 7, 64-bit R 2.15.1 (32- & 64-bit) Microsoft SQL Server 2008 Installation & Usage Download JDBC driver from Microsoft ( Link ) and install it so that RJDBC plugin is able to interact with SQL Server database via the Java interface. You can install the driver to a local folder, such as C:\Program Files\Microsoft SQL Server JDBC Driver 3.0 The latest RJDBC release...

Read More