R help - May 2012 - Loading the stupid dataset--help!!!

I am using the following: 
library(RODBC)
chan = odbcConnectExcel("rats-lda")
rats.lda = sqlFetch(chan, "data")
close(chan) 

And getting the following error message:
> library(RODBC)
Error in library(RODBC) : there is no package called
?RODBC?
> chan = odbcConnectExcel("rats-lda")
Error: could not find function
"odbcConnectExcel"
> rats.lda = sqlFetch(chan, "data")
Error: could not find function "sqlFetch"
> close(chan) 


I am sure there is a simple answer to this.  Thanks.

--
View this message in context:
http://r.789695.n4.nabble.com/Loading-the-stupid-dataset-help-tp4630585.html
Sent from the R help mailing list archive at Nabble.com.

On 05/19/2012 07:44 AM, SteveQ wrote:
> I am using the following:
> library(RODBC)
> chan = odbcConnectExcel("rats-lda")
> rats.lda = sqlFetch(chan, "data")
> close(chan)
>
> And getting the following error message:
>> library(RODBC)
> Error in library(RODBC) : there is no package called ?RODBC?
The above error message indicates that the ROBDC package is not
installed.  Have you done an install.packages("ROBDC")?
>> chan = odbcConnectExcel("rats-lda")
> Error: could not find function "odbcConnectExcel"
>> rats.lda = sqlFetch(chan, "data")
> Error: could not find function "sqlFetch"
>> close(chan)
>
>
>
> I am sure there is a simple answer to this.  Thanks.

-- 
Kevin E. Thorpe
Biostatistician/Trialist,  Applied Health Research Centre (AHRC)
Li Ka Shing Knowledge Institute of St. Michael's
Assistant Professor, Dalla Lana School of Public Health
University of Toronto
email: kevin.thorpe at utoronto.ca  Tel: 416.864.5776  Fax: 416.864.3016

?install.packages
This functionality may also be available from a menu in an R GUI, e.g.
on WIndows. But as you failed to provide your system details -- as
requested by the posting guide -- we can't say.

HOWEVER ... something appears to be rotten in Denmark (with apologies
to Peter D.). IIRC, RODBC is part of the standard library that should
be automatically installed when you install R. If so, then why isn't
it there? How did you install R? Do you have access to your library
directories where RODBC should reside?  What other packages do you
show in your session? If you post the results of sessionInfo(),
someone wiser than I may be able to help you if install.packages()
does not suffice.

-- Bert

On Sat, May 19, 2012 at 4:44 AM, SteveQ <couponsq at gmail.com>
wrote:
> I am using the following:
> library(RODBC)
> chan = odbcConnectExcel("rats-lda")
> rats.lda = sqlFetch(chan, "data")
> close(chan)
>
> And getting the following error message:
>> library(RODBC)
> Error in library(RODBC) : there is no package called ?RODBC?
>> chan = odbcConnectExcel("rats-lda")
> Error: could not find function "odbcConnectExcel"
>> rats.lda = sqlFetch(chan, "data")
> Error: could not find function "sqlFetch"
>> close(chan)
>
>
>
> I am sure there is a simple answer to this. ?Thanks.
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/Loading-the-stupid-dataset-help-tp4630585.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.


-- 

Bert Gunter
Genentech Nonclinical Biostatistics

Internal Contact Info:
Phone: 467-7374
Website:
http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm