Prof Brian Ripley
2009-Jun-25 08:53 UTC
[R] [R-pkgs] 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}}