On Mar 12, 2013, at 3:18 PM, Nuno Prista <nmprista at ipma.pt> wrote:
> Dear R colleagues,
>
> Is there any code I can use that allows an R 64bits to automatically run
code on an adjoining 32bits version?
>
> Specifically, I am using the "RODBC" package on a 64 bits version
and have a separate installation of R 32bits. I would like to automate data
extraction from Microsoft Access and Excel [for which RODBC seems to require R
32 bits] from within my 64 bits version.
>
> Thank you in advance,
The short answer is No.
The longer answer is that R, the ODBC drivers and the target application have to
be of the same architecture. Additional information is contained in various
locations:
1. Last paragraph in R Windows FAQ 2.28:
http://cran.r-project.org/bin/windows/base/rw-FAQ.html#Should-I-run-32_002dbit-or-64_002dbit-R_003f
2. Run vignette("RODBC") and then look at:
A. Lower half of page 23
B. Footnote 15 on page 26
Regards,
Marc Schwartz