SQL Server Import and Export Wizard: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
Basically, SSMS is a 32-bit application even when we install 64 bit SQL Installation. When we launch the SQL Server Import and Export wizard (DTSWizard) it runs the 32-bit version of it which needs the 32-bit version of Office libraries. if we have installed a 64-bit office then these office libraries will not talk to … [Read more…]