R packages - Jun 2009 - RODBC 1.2-6 on CRAN, future directions

Version 1.2.6 of RODBC is now on CRAN.  This has a number of bug fixes and many 
workarounds for ODBC driver quirks--I've set up further testbeds for SQL
Server
2008, Oracle and DB2.

More visibly, the documentation has been expanded in several ways, in 
particular in collecting together advice on using 'schemas' and
'catalogs' in
the ?RODBC overview.

There is also a test suite which although mainly useful for the maintainer 
provides some more detailed examples of working with the quirks of various 
backends (and has examples for Oracle's own Windows ODBC driver). 
Contributions of adaptations of those examples to other drivers would be 
welcome (especially for Sybase and other ODBC drivers for Oracle).

In the next version much of the documentation will be moved from the help pages 
to a package manual: a draft of that manual appropriate to RODBC 1.2-6 can be 
found at http://www.stats.ox.ac.uk/pub/bdr/RODBC-manual.pdf

Other planned changes are speed-ups for Oracle (currently 4x on the test 
suite), more support for schemas (that in 1.2-6 is just a first step, but the 
behaviour of the ODBC drivers is remarkably inconsistent) and support for
R's
'raw' type.

-- 
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

_______________________________________________
R-packages mailing list
R-packages at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-packages

R 2.8
Windows XP
Excel 2003

I am trying to read an Excel spread sheet. I have looked at the RODBC help pages
and am having trouble setting up code that will work. My code and the results
are pasted below:

>
jo<-odbcConnectExcel("i:\\all\\sorkinjohn\\stats\\silvermannatalie\\NEMOcombined06-24-09.xls",readOnly
= TRUE)
> mo<-sqlGetResults(jo)
> mo
[1] -1

I have tried to set up the connection string using odbcConnectExcel and then
have tried to read the file using sqlGetResults. Can someone tell me what I am
doing wrong?

Thanks,
John

John David Sorkin M.D., Ph.D.
Chief, Biostatistics and Informatics
University of Maryland School of Medicine Division of Gerontology
Baltimore VA Medical Center
10 North Greene Street
GRECC (BT/18/GR)
Baltimore, MD 21201-1524
(Phone) 410-605-7119
(Fax) 410-605-7913 (Please call phone number above prior to faxing)

Confidentiality Statement:
This email message, including any attachments, is for th...{{dropped:6}}