[R] RODBC and Excel in Widows

r.ghezzo r.ghezzo at staff.mcgill.ca
Wed Mar 26 15:05:59 CET 2003

 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

More information about the R-help mailing list