RODBC connect to Excel (64-bit Windows 7)
If you're using (R)ODBC, you need a workflow that is either 32bit or 64-bit, but not mixed. On a 64-bit Windows 7 machine, I can use 32-bit R and RODBC to read and write 32-bit Excel (etc) and similarly xlsreadwrite works 32-bit. I can use 64-bit R and XLConnect to read and write from excel spreadsheets that then open nicely in 32-bit Excel. Just requires a little care to know whether your workflow is 32 or 64 bit. Paul --------------------------------------------------------- Paul Bivand Associate Director of Analysis and Statistics Centre for Economic & Social Inclusion 3rd floor, 89 Albert Embankment, London SE1 7TP Inclusion website www.cesi.org.uk
On 23 May 2012 18:20, IzRey <brett.israelsen at gmail.com> wrote:
andrija djurovic <djandrija <at> gmail.com> writes:
Hi to all. ...... Thanks in advance Andrija
I am having the exact same problem. Any luck with this yet?
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.