SSIS and Excel Bugs

Some helpful links for importing data from Excel to SQL Server using SSIS:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

https://www.wiseowl.co.uk/blog/s2531/loop-over-excel-worksheets.htm

https://www.wiseowl.co.uk/blog/s2492/excel-worksheets-loop.htm

Choose to install the 32 bit version of the driver above, and then you will see, in the Connection manager, the following option for connecting to Excel: