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 …