[R] convert excell file to text with RODBC package

Prof Brian Ripley ripley at stats.ox.ac.uk
Fri Apr 2 18:04:37 CEST 2004


On Fri, 2 Apr 2004 solares at unsl.edu.ar wrote:

> And the second question is the command odbcFechRows() don't work,

That is not a question, that is an assertion!  There is no such function, 
and I presume you mean odbcFetchRows().

> for example if write
> tbl<-odbcFetchRows(canal) in place of sqlFetch result a error
> stat = -1 and the list is NULL
> odbcGetErrMsg return No results available. Thank Ruben

If you used odbcFetchRows(), it worked exactly as documented.  Please do
read the help pages!  Hint: you had no `pending rowset'.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
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, UK                Fax:  +44 1865 272595




More information about the R-help mailing list