[R-SIG-Mac] RODBC

[Dan Putler]

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.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]]
> 
-- 
Dan Putler
Sauder School of Business
University of British Columbia