[R] Reading access file

[Jeff Newmiller]

Be sure to use the 32bit version of R with the code below. This is a limitation of the ODBC driver for "mdb" files. If you use the odbcConnectAccess2007() function to connect to "accdb" files then you can use 64bit R.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On May 14, 2015 1:58:38 PM PDT, Wensui Liu <liuwensui at gmail.com> wrote:
>mdbConnect<-odbcConnectAccess("C:\\temp\\demo.mdb");
>sqlTables(mdbConnect);
>demo<-sqlFetch(mdbConnect, "tblDemo");
>odbcClose(mdbConnect);
>rm(demo);
>
>On Thu, May 14, 2015 at 6:31 AM, silvano <silvano at uel.br> wrote:
>
>> Hello everybody.
>>
>> I have a access file to read in R but I can’t to do this.
>>
>> I used Hmisc package, but it doesn’t work.
>>
>> Someone has the commands to read this kind of file?
>>
>> I attached the access file.
>>
>> Thanks.
>>
>> Silvano.
>> ______________________________________________
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> 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.
>
>
>
>
>-- 
>==============================
>WenSui Liu
>Credit Risk Manager, 53 Bancorp
>wensui.liu at 53.com
>513-295-4370
>==============================
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.