[R] RODBC and Excel in Widows
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")
>> 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
>> 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
R. Heberto Ghezzo Ph.D.
Montreal - Que - Canada
More information about the R-help