Microsoft.ACE.OLEDB.12.0 provider is not registered

SQL Server Import and Export Wizard
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

1.當SSMS是在x64的主機，且主機有安裝64bit Office，此時只能下載安裝AccessDatabaseEngine_X64.exe

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

然後，使用64 bit的SQL Server Import and Export Wizard
C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTSWizard.exe

2.當SSMS是在x64的主機，且主機有安裝32bit Office，此時只能下載安裝AccessDatabaseEngine.exe

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

然後，使用32 bit的SQL Server Import and Export Wizard
C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\DTSWizard.exe