Skip to content

Reading access file

4 messages · Silvano, Kehl Dániel, Wensui Liu +1 more

Original
Silvano
# 
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.
Kehl Dániel
# 
Hi Silvano,

your attachment did not go through (only a couple of formats are supported). Please try to give your code next time and what error you get but first read this, it might help:

http://www.statmethods.net/input/dbinterface.html

best,
daniel
________________________________________
Felad?: R-help [r-help-bounces at r-project.org] ; meghatalmazó: silvano [silvano at uel.br]
K?ldve: 2015. m?jus 14. 13:31
To: R
T?rgy: [R] Reading access file

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
# 
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:

            

      
      
      
    

        

      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      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: