When creating an OLEDB Data Source, using Microsoft Excel (XLSX) files, there is no drop down showing which worksheet to import from.
ITMS 8.7.x
Known Issue.
This issue has been reported to our Development team. A fix for this issue has been added to our ITMS 8.7.3 release.
Workaround:
You can use a CSV data source for this import.