Error in Excel Import : Unable to connect to Excel, make sure given file is an valid Excel file

Error in Excel Import : Unable to connect to Excel, make sure given file is an valid Excel file

This issue could be due to OLEDB driver missing in the respective system, where the application is running. It can be downloaded from the below link and installed.