The name of the download is 'Microsoft Access Database Engine 2010 Redistributable' as this 64bit ACE OLEDB Provider is the result of our Office 2010. It has been around in the scene with Office 2007 but it was available as 32bit only. Bug 56904 - Bundle Microsoft Access Database Engine 2010 Redistributable Summary: Bundle Microsoft Access Database Engine 2010 Redistributable Status. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. I needed both the 32-bit and the 64-bit adapters to cover my various use cases. I started by installing the 64-bit Microsoft Access Database Engine 2010 Redistributable. If you have ever attempted this, you know there is a secret. Microsoft Access Database Engine 2010 Redistributable This download will install a set of components that.
- Microsoft Access Database Engine 2010 Redistributable Download 32-bit
- Microsoft Access Database Engine 2010 Redistributable Download 32-bit
- Access Database Engine 2013 Redistributable
I cannot access my Excel sheets in SSIS. The Excel version in the Connection Manager is Microsoft Excel 2007 (xlsx).
| Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection Manager' |
Solution
XLSX files don't use the out-of-the-box Microsoft.Jet.OLEDB provider, but they need the Microsoft.ACE.OLEDB provider. You either did not install it or you installed the 64bit version.
Download and install the 32bit version of the Microsoft Access Database Engine 2010 Redistributable. Because Visual Studio (SSDT/BIDS) is 32bit you can't use the 64bit provider for developing SSIS packages. If you already installed the 64bit version then you first need to remove it. You can't install 32bit and 64bit parts of office on the same machine. You will get an error when you run the installer (and you will get the same error if you have a 64bit version of Microsoft Office installed on your development machine):
| You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2010, your first need to remove the 64-bit installation of office products. |
Microsoft Access Database Engine 2010 Redistributable Download 32-bit
Microsoft Access Database Engine 2010 Redistributable Download 32-bit
However this means that you can't run packages with Excel Connection Mangers in 64bit on your development machine. You need to switch to 32bit, otherwise you will get an error like:| Information: 0x4004300A at DFT - xlsx source, SSIS.Pipeline: Validation phase is beginning. Error: 0xC0209303 at xlsxSource, Connection manager 'Excel Connection Manager': The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: 'Microsoft OLE DB Service Components' Hresult: 0x80040154 Description: 'Class not registered'. Error: 0xC001002B at xlsxSource, Connection manager 'Excel Connection Manager': The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816 Error: 0xC020801C at DFT - xlsx source, EX_SRC - My XLSX Source [8]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager 'Excel Connection Manager' failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: 0xC0047017 at DFT - xlsx source, SSIS.Pipeline: EX_SRC - My XLSX Source failed validation and returned error code 0xC020801C. Error: 0xC004700C at DFT - xlsx source, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at DFT - xlsx source: There were errors during task validation. |
But since there is a 64bit driver... you could install it on your test/acceptance/production server and run the packages in 64bit (as long as you don't use Visual Studio on those servers).Access Database Engine 2013 Redistributable
More about Microsoft Access Database Engine 2010 Redistributable
Get the info about this program v12.0.6683.5002, its overall size is 25.32 MB; by the way, users can download this program under the name Microsoft Office Access database engine. Microsoft Corporation has developed the software and distributes it at no cost. It is classified as belonging to the Productivity category, namely Office Software. The most preferred versions of the program are 12.0 and 1.0 and they can be launched on Windows XP/Vista/7/8/8.1. It should be underlined that the installers OIS.EXE and MSACCESS.EXE are the most popular among users. The antivirus check of the direct download link proved it to be clean.
Download