0 Replies Latest reply on Jan 18, 2017 7:27 AM by Rishi Raj

    SW EPDM 2016 - Excel data source as a linked server in SQL Server 2014

    Rishi Raj

      Hello Team,

       

       

      Ref to PDM 2016 version, I am able to configure Excel and also able to retrieve the value when query from card list within PDM administrative window but as soon I used the list in Card then it shows as "Error executing card list query".

       

      As the server is 64 bit so below input is mentioned while adding excel as a linked server

       

      Provider- Microsoft Office 12.0 access database engine OLE DB provider

      Product Name- Excel

      Data source - D:\------\----.xlsx

      Provider String - Excel 12.0

       

      All works fine but when I use list in card, I receive the error.

       

      Any suggestion\advise.

       

      Thanks in advance

       

      Rishi