Excel Source - No tables or views could be loaded RRS feed

  • Question

  • I am using O365, Windows 10 and Visual Studio 2017.  I have installed Microsoft Access Database Engine 2016 Redistributable 64-bit.  I get the error 'No tables or views could be loaded' when setting up the Excel Connection Manager.  I have tried various connection strings and saving the Excel file in various versions.  I have also tried setting Run64BitRuntime to true or false.  I have also tried installing Microsoft Access Database Engine 2010 Redistributable and changing the connection string to earlier versions of Excel. 

    Please could you confirm the settings I should be using for all of the above as nothing I've tried has worked.

    Thursday, October 10, 2019 3:37 PM


All replies