title: Connection manager throw exception when loading .xlsb file using SSIS
body: <p>I have one .XLSB file (MS excel binary worksheet created using Office 2016) having more than million records. How can I load this using SSIS?
  I have both SQL server 2014 and SSDT 2012 &amp; SQL Server 2017 SSDT 2017 on two different PC.</p>
  
  <p>The problem is : In SSIS , I'm using excel source , connection manager as excel, the name of the excel sheet is not appearing. Saying, no table or view could be loaded. However, my excel has sheet in it.</p>
  
  <blockquote>
    <p>Could not retrieve the table information for the connection manager 'Excel Connection Manager'.
    Failed to connect to the source using the connection manager 'Excel Connection Manager'</p>
  </blockquote>
  
  <p><strong>EDIT more on error</strong></p>
  
  <p><a href="https://i.stack.imgur.com/Kv7WA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kv7WA.jpg" alt="enter image description here"></a></p>
  
  <p>As per this : <a href="https://stackoverflow.com/questions/389520/accessing-excel-2007-binary-xlsb-via-oledb-ace">Accessing Excel 2007 Binary (.xlsb) via OleDb ACE</a> installed the access (2016) engine. But, still having problem.</p>
  
  <p>What could be the problem ? Any link would help? Thanks.</p>