R help - Nov 2009 - Preferred Method for Reading in and Processing Access Database

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.

Thanks again.

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