[R] RODBC and Excel in Widows
david.meyer at ci.tuwien.ac.at
Wed Mar 26 15:23:51 CET 2003
You might look at Thomas Baier's DCOM interface as an alternative to the
odbc-method for accessing EXCEL-files.
> 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
Mag. David Meyer Wiedner Hauptstrasse 8-10
Vienna University of Technology A-1040 Vienna/AUSTRIA
Department of Tel.: (+431) 58801/10772
Statistics and Probability Theory Fax.: (+431) 58801/10798
More information about the R-help