I have been able to import. However, for some reason... when I try to perform Ssis on this particular excel file, i.e. BDE.xls, I hit an error:
External table is not in the expected format.
I have uploaded both the excel file and the image. Would be grateful for any advise.