[R] .Rprofile and RODBC

[Uwe Ligges]

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