Further to a post over 3 years ago https://tickett.wordpress.com/2011/09/27/updateable-excel-frontend-for-sql-view/ – I have finally given up the search for a ready made solution and built something myself.
I work with a number of systems which have functionality gaps and/or need a simpler (quicker) interface for data entry. The solution is essentially a SQL view (or stored procedure) with a simple grid (excel like) front-end. If any data needs to be captured not currently handled by the system a custom table is created to hold the fields.
My previous Excel based solution works rather well, but is starting to show it’s age. I am now beta testing a web based solution i have built;
The application is extremely simple to configure- enter the SQL to retrieve & update the data;
And list the columns with some attributes (ReadOnly, Hidden, Title, Width etc);
And you’re all set!
Functionality currently includes;
- Easy configuration
- Simple/fast data entry (with validation)
- Column resizing (non-persistent)
- Sort on any column
- Test (find and fix bugs)
- Optimise code
- Allow parameters in select SQL