[R] RODBC and Excel in Widows

[ripley@stats.ox.ac.uk]

Why don't you debug the code and send the patch needed to the maintainer?
R is supposed to be a collaborative project, and we need more 
contributors, especially on Windows.

Looking forwards to your positive contribution ....

On Wed, 26 Mar 2003, r.ghezzo wrote:

> HI,
>  no sorry, so far nobody answer. So it probably does not have a solution.
>  Excell is from you.know.who
> 
> >===== Original Message From Meinhard Ploner <meinhard.ploner at univie.ac.at> 
> =====
> >Hello!
> >Did you resolve the problem?
> >I'm interested in the solution, too.
> >Meinhard
> >
> >On Thursday, March 13, 2003, at 07:21  PM, R. Heberto Ghezzo wrote:
> >
> >> Hello, I have some problems with RODBC and Excel in Win98
> >> I am using R 1.6.2 and just upgraded RODBC to the last version on CRAN.
> >> I have an Excel file with columns Number, Name, Sex, Age, FEV1 on Sheet
> >> 1 and Number, Age, FEV1, Name, Sex on Sheet 2.
> >> Now I open the channel to the file
> >>> chan1 <- odbcConnectExcel("c:/testOdbc.xls")
> >>> tables(chan1)
> >> and the list appears with the 2 tables
> >>> aa -> sqlFetch(chan1,"Sheet1")
> >> and aa has the Number, Name and Sex columns correct but Age and FEV1
> >> are
> >> all NAs
> >>> bb -> sqlfetch(chan1,"Sheet2")
> >> and bb is correct!
> >> So all numeric columns after a column of characters become NAs
> >> Is this an Excel problem or an sql problem.? I did not find anything in
> >> the r-help archives relative to this problem.
> >> Thanks for any help
> >>
> >> ______________________________________________
> >> R-help at stat.math.ethz.ch mailing list
> >> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> >>
> 
> R. Heberto Ghezzo Ph.D.
> Meakins-Christie Labs
> McGill University
> Montreal - Que - Canada
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595