[R] Access Data Base Reading on Linux Platform

Lorenzo Isella lorenzo.isella at gmail.com
Mon Jul 31 12:51:15 CEST 2017

Dear All,
I am really far from a database expert (I do prefer flat files as long as
that is reasonable), but I have to deal with an accdb database (Microsoft
Access new format). It all stems from the fact that I run R almost
exclusively on Debian platforms.
I did a bit of googling




but it seems you cannot go very far unless you can install some microsoft
drivers on your platform.
Hence, my two questions

1) Can I read (I do not need write permissions) an accdb database on linux
using R without resorting to WINE?

2) If 1) is cumbersome, to what R friendly format (excluding for now a csv
dump) I can convert the data base? If this is doable entirely in Linux?
Otherwise, worse comes to worse, how to make this one time conversion from
Windows? I read there are ways from Access to convert everything to mdb,
which should be more R friendly, but I need the opinion of someone more
experienced than me here.

Many thanks


	[[alternative HTML version deleted]]

More information about the R-help mailing list