如何从Microsoft Access将.accdb数据库文件读取到R?

如何从Microsoft Access将.accdb数据库文件读取到R?

问题描述:

RODBC 文档表明可能,但我不知道如何从Microsoft Access中读取数据(新的 .accdb 格式)文件与此包到R(在Debian GNU / Linux)。小插图谈到驱动程序,但我不太明白我如何看到安装了哪些驱动程序,特别是如果我安装了一个驱动程序,我访问这些 .accdb 文件。

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.

您使用什么代码从 .accdb 文件读取数据?

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.

您链接的网页的标题, RODBC:ODBC数据库访问,可能会产生误导。访问不是指MS访问;在该标题访问意味着连接。 RODBC是R的ODBC管理器。它充当调解器,为R和目标数据库的ODBC驱动程序之间提供通信。所以对于GNU / Linux,你仍然需要一个用于MS Access数据库文件的ODBC驱动程序... RODBC不提供。

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.

但是,我不知道任何免费(如自由和/或啤酒)MS Access ODBC驱动程序的Linux。 Easysoft销售一个,但它不便宜。也可能有来自其他供应商的产品;我没有看过。

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.

使用Windows计算机将ACCDB导出为R可以使用的格式可能更容易。或者在Windows上运行 R,而不是Linux。

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.