Update particular table columns from SQL Server RRS feed

  • Question

  • I have a Table ListObject with columns PartNumber, Quantity, ExtendedCost, Description, & Cost.  

    PartNumber is a static value manually typed into the Table and is a primary key on a SQL Server table.  PartNumber is often duplicated in the Excel table as you can see in my example picture below.

    Quantity is made up of several formulas.

    ExtendedCost is a formula "=[@Quantity]*[@Cost]". 

    Description and Cost I want to refresh from the SQL Server table.

    Can I create and save a query that will just read/update Description and Cost from my database using PartNumber in the Excel workbook?  Note, I'm currently using VB.NET for Windows Forms to open the workbook and I need to call this refresh using VB.NET.


    Thursday, December 12, 2019 5:27 PM