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:<jdnew...@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 <liuwen...@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 <silv...@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@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....@53.com
>513-295-4370
>==============================
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help@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.
______________________________________________
R-help@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.
