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
Nick Drew wrote:> 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?Why do you think it does not? What is in there which you think is not executed? You are talking about R-2.0.0 and R-1.9.1?> 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)) > } >Works for me. What does the error message say? Do you have a recent version of RODBC compiled for R-2.0.0? Uwe Ligges> 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 > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html