[R] RODBC connect to Excel (64-bit Windows 7)

Paul Bivand paul.bivand at gmail.com
Fri May 25 14:14:16 CEST 2012


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.



More information about the R-help mailing list