Sample 17 - Budget Request

Sample 17 - Budget Request

This sample shows how database developers may create forms like budget requests with Microsoft Excel.

It's quite simple:

  1. You have to create master and data tables.
  2. You have to create a stored procedure used as a form.
  3. You have to create stored procedures used to insert, update, and delete rows.
  4. You have to create a procedure to select report data in Microsoft Excel.
  5. You have to configure the SaveToDB add-in using the xls.handlers table.

As a result, users can use Microsoft Excel to input and consume data.