Post reply

Excel Connection Error: "External table is not in the expected format"

  • January 17, 2020 at 10:38 am

    #3716240

    I did have the same problem with excels exported from SSRS. Haven't tried to fix it beyond opening the excel and saving it again with excel

    • This reply was modified 5 years, 10 months ago by Jo Pattyn.

  • January 17, 2020 at 11:37 am

    #3716257

    Who or what is the source of the excel files?  Could it be where the source is has exported them as 2013 office format or above?  If it's a 3rd party then your going to have to re-work the connection strings for the updated providers.

     

    Office 2010 goes out of support this year, highly recommend you start the upgrade process and sharpish to ensure everything is tested and signed off, otherwise your going to leave yourselves open to potential attack surfaces by using out dated software.

  • January 17, 2020 at 11:56 am

    #3716263

    Can you confirm that all of the files are in .XLS format?

    Probably unrelated, but I saw this error when I tried to open a .XLSB file using a (ACE) .XLSX connection string.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply