microsoft access Redistributable 和 runtime 有什么区别? [英] What is the difference between microsoft access redistributable and runtime?
问题描述
为了能够通过 SSIS 工作流使用 Excel，我需要安装适当的插件.可再发行和运行时有什么区别?
示例:
Access Runtime
基于 Microsoft Access 2010 运行时下载页面:
<块引用>Microsoft Access 2010 Runtime 使您能够将 Access 2010 应用程序分发给计算机上未安装完整版 Access 2010 的用户.
此包用于部署 Microsoft Access 应用程序.可以在 以下文章.(检查了解并下载 Access Runtime"部分)
在该文档中，他们提到:
<块引用>要部署无需在用户计算机上安装 Access 即可运行的 Access 应用程序，您可以将它们与 Access Runtime 一起分发，后者可从 Microsoft 下载中心免费获得.当您使用 Access Runtime 打开 Access 数据库时，该数据库会以运行时模式打开.
<块引用>
运行时模式是一种 Access 操作模式，其中某些 Access 功能默认不可用.但是，其中一些不可用的功能可以在运行时模式下使用.
数据库引擎可再发行
在 Microsoft Access Database Engine 2010 Redistributable 下载页面 他们提到:
<块引用>此下载将安装一组组件，可用于促进 2010 Microsoft Office System 文件和非 Microsoft Office 应用程序之间的数据传输.
<块引用>
此下载将安装一组组件，以促进现有 Microsoft Office 文件之间的数据传输，例如 Microsoft Office Access 2010(*.mdb 和 .accdb)文件和 Microsoft Office Excel 2010(.xls、*.xlsx 和 *.xlsb) 文件传输到其他数据源，例如 Microsoft SQL Server.还支持与现有文本文件的连接.安装了 ODBC 和 OLEDB 驱动程序，供应用程序开发人员用于开发与 Office 文件格式连接的应用程序.
回答您的问题
回到您的问题，您需要安装 Microsoft Access Database Engine Redistributable，因为它包含 Microsoft Access 和 Excel 所需的 OLE DB 和 ODBC 驱动程序.
To be able to use Excel via SSIS workflow, I need to install the appropriate plugin. What is the difference between redistributable and runtime?
Example:
Access Runtime
Based on the 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.
This package is used to deploy Microsoft Access applications. Lots of details can be found in the following article. (Check the "Understand and download the Access Runtime" section)
In that documentation they mentioned that:
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.
Database Engine Redistributable
On the Microsoft Access Database Engine 2010 Redistributable download page they mentioned that:
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.
Answering your question
Back to your question, the Microsoft Access Database Engine Redistributable is the one that you need to install since it contains the needed OLE DB and ODBC drivers for Microsoft Access and Excel.
这篇关于microsoft access Redistributable 和 runtime 有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
