I want to read excel file using SSIS package.
For this I’m planning on using the excel data source task.
In the connection manager it allows me to choose options like: 2010, 2013, 2016
My excel file is a latest excel file using latest excel software, I believe it is called Office 365 now..
Is there nothing after 2016 in the ssis excel data source task?
Do I need to install any driver to see options after 2016? Like maybe 2021 or office 365?
What is the latest excel data source driver?