Microsoft Access Database Engine 2010

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.
Its purpose is to allow non-Office systems to transfer data to and from Office files. 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). Additionally, it supports connectivity to text files.
Developers 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. To use this feature, you must configure the Provider argument (ConnectionString property) during the installation process.
Before 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. Please note that this package cannot replace Jet and it is not a tool that you can use to edit Office files.
Microsoft Access Database Engine 2010 is capable of granting applications reading and writing permissions for documents previously created with Microsoft Office Excel, Microsoft Office Access and text files.
With its help, you will be able to easily transfer large data sets from Excel spreadsheets or Access databases to SQL Server or other application, without encountering any difficulty or problem during the importing operation.