[R-SIG-Mac] RODBC

[Neil Tiffin]

http://www.actualtech.com/

Neil

On Mar 6, 2010, at 12:34 PM, Ivan Calandra wrote:

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