[SOLVED] SQL Server : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

This provides a walk around to resolve issues in SQL Server while importing data from Excel.

The problem statement is as follows : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

Steps to do :

1. Open the original Excel file.
2. Save it as Microsoft Excel 97-2003 Worksheet (.xls)
3. Repeat importing it into SQL Server.