Hi Ivan, Do you have an Excel ODBC driver? My understanding is that Microsoft does not provide one of OS X, so you may need to buy a driver to get it to work. I know a company called Opensoft makes one.
Dan On Sat, 2010-03-06 at 09:17 -0800, Ivan Calandra wrote: > Dear Mac users, > > Up to now, I've run R on Windows and I have some problems using my scripts on > Mac OS X 10.6, R.app GUI 1.31 (5537 Leopard build 64-bit). > > Here is the code I use to export a data.frame to an *.xls file: > xlsFile <- odbcConnectExcel("test.xls", readOnly=F) > sqlSave(xlsFile, test, tablename=test, rownames=F, addPK=T, append=F) > odbcCloseAll() > > However, the function odbcConnectExcel() doesn't work on Mac. > > Could you help me transposing this code? > > I don't think some sample data would be necessary, but let me know if you > would like to. > > Thanks in advance > Regards, > Ivan > > -- > Ivan CALANDRA > PhD Student > University of Hamburg > Biozentrum Grindel und Zoologisches Museum > Abt. Säugetiere > Martin-Luther-King-Platz 3 > D-20146 Hamburg, GERMANY > +49(0)40 42838 6231 > ivan.calan...@uni-hamburg.de > > ********** > http://www.for771.uni-bonn.de > http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php > > > > > > > [[alternative HTML version deleted]] > -- Dan Putler Sauder School of Business University of British Columbia _______________________________________________ R-SIG-Mac mailing list R-SIG-Mac@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac