Message-ID: <loom.20091119T001054-12@post.gmane.org>
Date: 2009-11-18T23:17:10Z
From: Michael Bibo
Subject: Preferred Method for Reading in and Processing Access Database
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