[R] Get data from Access 2010 database

Jeff Newmiller jdnewmil at dcn.davis.ca.us
Wed Mar 28 07:28:59 CEST 2012

AFAIK you need to use the 32bit version of R for getting the data. Then you can save it into a more versatile format and re-read it if you really need to run R in 64 bit mode.
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.

kpzimmer <kpzimmer at ucalgary.ca> wrote:

>I'm new to R and am trying to access data from a Microsoft Access 2010
>database. I've read through the RODBC package vignette and seem to
>understand the instructions of the commands but can't see to connect to
>database. I have installed the Access Database Engine from the
>website.  I get the following errors when I try to connect:
>> channel <- odbcConnect("K:/UWRRDatabase_9Feb2012")
>Warning messages:
>1: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") :
>  [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
>Manager] Data source name not found and no default driver specified
>2: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") :
>  ODBC connection failed
>I setting up a ODBC connection in ODBC data sources in the
>Tools of Control panel and also through
>but I must not be setting things up correctly.
>Any advice or suggestions to solve this problem would be much
>Thanks in Advance. 
>View this message in context:
>Sent from the R help mailing list archive at Nabble.com.
>R-help at r-project.org mailing list
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list