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

2012-05-25 Thread Paul Bivand
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

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

2012-05-25 Thread Gabor Grothendieck
On Sun, Dec 4, 2011 at 9:40 AM, andrija djurovic djandr...@gmail.com wrote: Hi to all.  I have a problem to connect to an Excel database using RODBC. There are tips for RODBC as well as some alternatives listed here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows -- Statistics

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

2012-05-23 Thread IzRey
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@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE

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

2011-12-04 Thread andrija djurovic
Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) channel - odbcConnectExcel(results.xlsx) Error in odbcConnectExcel(results.xlsx) : odbcConnectExcel is only usable with 32-bit

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

2011-12-04 Thread R. Michael Weylandt michael.weyla...@gmail.com
Do you need to use RODBC specifically? I've been using XLConnect quite a lot recently and have been quite pleased with it. Michael On Dec 4, 2011, at 9:40 AM, andrija djurovic djandr...@gmail.com wrote: Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am

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

2011-12-04 Thread andrija djurovic
Hi. Not specifically, but I used it before with 32-bit R under Windows XP and it worked just fine so i though to keep using it.Anyway I will lookt at XLConnect. Thank you for suggestion. Andrija On Sun, Dec 4, 2011 at 7:41 PM, R. Michael Weylandt michael.weyla...@gmail.com