[R-SIG-Mac] RODBC

[Simon Urbanek]

On Mar 6, 2010, at 12:17 PM, 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.
> 

Have you installed the necessary ODBC drivers and registered them?

Cheers,
Simon


> 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.calandra at uni-hamburg.de
> 
> **********
> http://www.for771.uni-bonn.de
> http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php
> 
> 
> 
> 
> 
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac