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.
Preferred Method for Reading in and Processing Access Database
2 messages · Jason Rupert, 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