Please note that this package cannot replace Jet and it is not a tool that you can use to edit Office files. To use this feature, you must configure the Provider argument (ConnectionString property) during the installation process.īefore installing the package, you are advised to remove any existing version of the Access Database Engine from your computer, in order to avoid incompatibiltiy issues. Additionally, it supports connectivity to text files.ĭevelopers will be glad to find out that the package also bundles ODBC and OLEDB drivers, which work together in order to help them implement support for Office file formats within their projects. For instance, it can be used to enable Microsoft SQL Server to import data from existing Access database files (MDB or ACCDB) or Excel worksheets (XLS, XLSX, XLSB). Its purpose is to allow non-Office systems to transfer data to and from Office files.
Microsoft Access Database Engine 2010 comprises a set of components that can be used in order to allow the communication and data exchange between files that are proprietary to the Office 2010 package and other applications.
