You might look at Thomas Baier's DCOM interface as an alternative to the odbc-method for accessing EXCEL-files.
-d "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 <[EMAIL PROTECTED]> > ===== > >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 > >> > >> ______________________________________________ > >> [EMAIL PROTECTED] 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 > > ______________________________________________ > [EMAIL PROTECTED] mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help -- 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 ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help