[R] Preferred Method for Reading in and Processing Access Database

[Michael Bibo]

Jason Rupert <jasonkrupert <at> yahoo.com> writes:

> 
> By any chance is there a preferred way to allow R to read in data from an 
Access Database and then also process
> that data?   
> 
> Thanks for any hints and tips since I have traditionally been working with 
csv file. 
> 

I find using package RODBC quite straightforward.  I usually create a query in 
Access to assemble the data I want from various tables, and then just access 
the query from R via RODBC.

Michael Bibo
Queensland Health