[R] Get data from Access 2010 database

[Prof Brian Ripley]

On 28/03/2012 06:28, Jeff Newmiller wrote:
> 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.

Not quite: you need to run R of the same architecture as your ODBC 
drivers, which in this case is the same architecture as your version of 
ADE (usually installed as part of Office).  We don't have the 'at a 
minimum' information required by the posting guide, so I at least do not 
know what version of Windows nor what architecture of R was used.

More details in the RODBC manual ....


> ---------------------------------------------------------------------------
> 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:
>
>> Hello,
>>
>> 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
>> the
>> database. I have installed the Access Database Engine from the
>> Microsoft
>> 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
>> Administrative
>> Tools of Control panel and also through
>> C:\WINDOWS\SysWOW64\odbcad32.exe
>> but I must not be setting things up correctly.
>>
>> Any advice or suggestions to solve this problem would be much
>> appreciated.


-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595