Hello R-Help, is there any way of using the RODBC Package on a Mac OS X System? If yes, what do I need to get it running. Concerning these issues, I am pretty unexperienced, so please state any step necessary. The actual problem is accessing data in Excel- files. (unfortunately no alternative way of entering the data). I already installed the Package, but it says the following:> versuch <- odbcConnectExcel("Thermanali-Versuch.xls")Error: couldn't find function "odbcConnectExcel" Thanks in Advance Stephan Freyberger
On Fri, 11 Mar 2005, Stephan Freyberger wrote:> Hello R-Help, > > is there any way of using the RODBC Package on a Mac OS X > System? If yes, what do I need to get it running. Concerning these > issues, I am pretty unexperienced, so please state any step > necessary. The actual problem is accessing data in Excel- files. > (unfortunately no alternative way of entering the data). > I already installed the Package, but it says the following: > >> versuch <- odbcConnectExcel("Thermanali-Versuch.xls") > Error: couldn't find function "odbcConnectExcel"As the documentation says very clearly, odbcConnectExcel is only available on Windows. Do you have an Excel ODBC driver? If so, set up a DSN to point it at the file you want and call odbcConnect() with that DSN. -- 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
The read.xls() function in the gdata package in the gregmisc bundle will import data from Excel spreadsheets on OS X. I've used it with R 2.0.1 on Mac OS X 10.2.8, and the current version of Excel. -Don At 9:53 AM +0000 3/11/05, Stephan Freyberger wrote:>Hello R-Help, > >is there any way of using the RODBC Package on a Mac OS X >System? If yes, what do I need to get it running. Concerning these >issues, I am pretty unexperienced, so please state any step >necessary. The actual problem is accessing data in Excel- files. >(unfortunately no alternative way of entering the data). >I already installed the Package, but it says the following: > >> versuch <- odbcConnectExcel("Thermanali-Versuch.xls") >Error: couldn't find function "odbcConnectExcel" > >Thanks in Advance > >Stephan Freyberger > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html-- -------------------------------------- Don MacQueen Environmental Protection Department Lawrence Livermore National Laboratory Livermore, CA, USA