[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) {
 x <- sqlFetch(odbcConnectExcel(file.choose()),
"exceldata", na.strings = "NA")
 odbcCloseAll() #closes the connection

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

Thanks in advance for you help.


More information about the R-help mailing list