[R] RODBC and Excel in Widows
ripley at stats.ox.ac.uk
Wed Mar 26 15:24:35 CET 2003
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:
> 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>
> >Did you resolve the problem?
> >I'm interested in the solution, too.
> >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
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
More information about the R-help