Sample 17 - Budget Request
This sample shows how database developers may create forms like budget requests with Microsoft Excel.
It's quite simple:
- You have to create master and data tables.
- You have to create a stored procedure used as a form.
- You have to create stored procedures used to insert, update, and delete rows.
- You have to create a procedure to select report data in Microsoft Excel.
- 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.