import from excel to sql server: The ‘Microsoft.ACE.OLEDB.12.0’ provider error

I want to import data from excel to sql server, but I got error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

op: windows 10 64 bit
excel: 32 bit

There is no problem with older excel format xls, problem occurs with xlsx format.
Is there any esay way to fix this?

Answer

install the following file from microsoft to fix this issue

https://www.microsoft.com/en-us/download/details.aspx?id=13255