Re: [R-SIG-Mac] RODBC

2010-03-06 Thread 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 -

Re: [R-SIG-Mac] RODBC

2010-03-06 Thread 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,

Re: [R-SIG-Mac] RODBC

2010-03-06 Thread Marc Schwartz
On Mar 6, 2010, at 11:17 AM, 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 -

Re: [R-SIG-Mac] RODBC

2010-03-06 Thread 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

Re: [R-SIG-Mac] RODBC

2010-03-06 Thread Marc Schwartz
Ivan, A quick heads up. I had a brief offlist exchange with Prof. Ripley, during which he noted two things: 1. His MS Office 2008 installation on OSX does not have an ODBC driver. So it would seem that it is not available from MS, which would make sense with Actual Tech selling one. 2. The

Re: [R-SIG-Mac] RODBC

2010-03-06 Thread Kent Manley
I might suggest looking into the possibility of using SQLite, which is cross platform and free (in fact, it's public domain rather than GNU etc.). You can then set up an Excel spreadsheet to populate itself from the SQLite db. http://www.sqlite.org. It's already available on the Mac -