Test connection failed because of an error in initializing provider external table , External Table is not in the Expected Format.

PROBLEM:- While Creating the Source Excel Connection in SSIS we are getting the following error

The test connection failed because of an error in initializing the provider’s external table, External Table is not in the Expected Format.

SOLUTION:- To Resolve this issue Open the Excel file which you are using and Re-save the file in Excel 97-2003 Workbook format.

Try to create the Connection again and the Connection will be successful this time.