excel - microsoft access redistributable 和 runtime 有什么区别？

Question

为了能够通过 SSIS 工作流使用 Excel，我需要安装适当的插件。可再发行和运行时有什么区别？
例子:

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access 2010 Runtime

Answer 1

Access 运行时
基于Microsoft Access 2010 Runtime download page :

The Microsoft Access 2010 Runtime enables you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers.

此包用于部署 Microsoft Access 应用程序。很多细节可以在 the following article 中找到. (查看“了解并下载 Access Runtime”部分)
在该文档中，他们提到:

To deploy Access applications that can run without an installation of Access on a user's computer, you can distribute them along with the Access Runtime, which is available for free from the Microsoft Download Center. When you open an Access database by using the Access Runtime, the database opens in runtime mode.

Runtime mode is an Access operating mode in which certain Access features are not available by default. Some of these unavailable features can be made available in runtime mode, however.

数据库引擎可再发行组件
在 Microsoft Access Database Engine 2010 Redistributable download page他们提到:

This download will install a set of components that can be used to facilitate the transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.

This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and .accdb) files and Microsoft Office Excel 2010 (.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

回答你的问题
回到您的问题， Microsoft Access 数据库引擎 Redistributable 是您需要安装的 因为它包含 Microsoft Access 和 Excel 所需的 OLE DB 和 ODBC 驱动程序。