[R] .Rprofile and RODBC

Nick Drew drewbrewit at yahoo.com
Mon Oct 25 15:46:32 CEST 2004


Since installing R 2.0 I've had the following 2 issues
I can't find solutions for. I'm using Windows XP.

1) R 1.9 continues to read my .Rprofile file in my
home directory but R 2.0 does not. How do I get R 2.0
to do this?

2) The following function no longer works in R 2.0 but
continues to work in R 1.9:


getExcel <- function (x) {
 invisible(require(RODBC))
 x <- sqlFetch(odbcConnectExcel(file.choose()),
"exceldata", na.strings = "NA")
 odbcCloseAll() #closes the connection
 invisible(edit(x))
}


I use this function to choose an Excel file and open
it using an ODBC connection. Why does this not work
now?


Thanks in advance for you help.

~Nick




More information about the R-help mailing list