I'm trying to connect to an Excel Source, my Excel file version is 2021, but the available choices are like below (3.0 4.0 2007-2010 2013 and 2016): enter image description here so whatever the version I'm trying to choose, no one could read the sheet or table in the Excel source. so, how can I resolve this !? Thanks.
I tried all the available versions
1条答案
按热度按时间dgiusagp1#
On my experience if your excel file extension is ".xlsx" and your 32-bit ACE OLE DB data provider installed you can choose 2007-2010 version from Excel Connection Manager. Download 32-bit ACE OLE DB data provider and check the result. You can find detailed answers from here