I'm trying to import data from Excel to my SQL Server database but when I open it, I get this error:
The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)
I don't know if it has something to do with using the 32 bit or the 64 bit version of the wizard and I have no clue which one to use.
I used the normal method where I went to SSMS, selected the database -> tasks -> import data, then I provided the Excel file path & Excel version but it still throws this error.