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

3
votes

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?

1
sqlsql-serverexcel

1 Answers

4
votes

install the following file from microsoft to fix this issue

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