locked
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

Answers

All replies

  • I think the different flavour needs to be installed, the server one not Microsoft Access Database Engine 2016 Redistributable 64-bit.

    Mind Run64BitRuntime should be on if you want to operate under 64 bit. I suggest you install both 32, and 64 variations.


    Arthur

    MyBlog


    Twitter

    Thursday, October 10, 2019 3:41 PM
  • Hi TGD_UK_99,

    I recently answered a similar question.

    Please check it out: Excel Source stopped working in SSIS

    • Marked as answer by TGD_UK_99 Thursday, October 10, 2019 4:24 PM
    Thursday, October 10, 2019 3:44 PM
  • Thank you so much Yitzhak Khabinsky, that has worked!
    Thursday, October 10, 2019 4:27 PM