SSIS ERROR – The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available
In order to fix the import issue from Excel file in a 64Bits environment using SSIS, just click project properties and turn the Run64BitRunTime to False. Good luck guys