RE: [R] RODBC and Excel in Widows
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
Re: [R] RODBC and Excel in Widows
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 MeyerWiedner 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
RE: [R] RODBC and Excel in Widows
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: 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 -- Brian D. Ripley, [EMAIL PROTECTED] 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, UKFax: +44 1865 272595 __ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help