[R-SIG-Mac] RODBC

[Ivan Calandra]

How am I supposed to do that? 

Marc Schwarz advised me to use the package WriteXLS instead.

Thanks for your help already
regards,
Ivan

Le 6 mars 2010 à 18:37, Simon Urbanek a écrit :

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



--
Ivan CALANDRA
PhD Student
University of Hamburg
Biozentrum Grindel und Zoologisches Institut und Museum
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