如何将 Microsoft Access .accdb 数据库文件中的数据读入 R? [英] How to read data from Microsoft Access .accdb database files into R?
问题描述
The RODBC documentation suggests it is possible, but I am not sure how to read data from a Microsoft Access (the new .accdb
format) file with this package into R (on Debian GNU/Linux). The vignette talks about drivers, but I do not quite understand how I can see which drivers are installed, and in particular, if I have a driver installed for me to access those .accdb
files.
What code do you use to read data from .accdb
files? And please indicate what platform you are on and if you had to install a special driver.
The title of the page you linked, RODBC: ODBC Database Access, may be misleading. Access doesn't mean MS Access; in that title access means connectivity. RODBC is an ODBC manager for R. It serves as the mediator to provide communication between R and the ODBC driver for your target database. So for GNU/Linux, you would still need an ODBC driver for MS Access database files ... RODBC doesn't provide one.
However, I don't know of any free (as in freedom and/or beer) MS Access ODBC drivers for Linux. Easysoft sells one, but it's not cheap. There may be offerings from other vendors, too; I haven't looked.
It might be easier to use a Windows machine to export your ACCDB to a format R can use. Or run R on Windows instead of Linux.
这篇关于如何将 Microsoft Access .accdb 数据库文件中的数据读入 R?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!