[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