Yes, you can use Frontpage extension for that.
You have to add a submit-button and have some kind of webserver to receive the submit.
We have made a Flash movie showing how to save into Access database using Frontpage extension:
The advanced service will let you store the data into a database on our server. The data can be retrieved as HTML and Excel-reports.
SpreadsheetConverter for HTML cannot handle database connections. The only solution is to regenerate the spreadsheet web page each day. However, that doesn’t seem to be a very good solution.
SpreadsheetConverter generates a standard web form. When the user presses submit, the data is posted to a web page of your choice.
You will have to create a simple PHP-page that parse the parameters and creates an sql-insert statement and runs it towards your database.
This type of code is very simple and part of standard PHP-books.
For example see
and how to store into a mySQL database, see here
At the last link, they have combined the HTML-form and the PHP-file into one file. This is not necessary. First have the HTML-page and only make sure the action points at your PHP-page that extracts the data and stores it into a database.
SpreadsheetConverter can only calculate and collect data, not show previously saved data. It seems to me that you need some kind of online database. We have created such a solution:
The turn-key solution called SpreadsheetServer will let you view, edit and save spreadsheets using any browser. You can share a spreadsheet online and the users do not need Excel at all. All data will be stored in a relational database. The data can be filtered, consolidated and accessed through reports and as Excel spreadsheets. Spreadsheets or single worksheets can be protected by password.
It is intended for applications like custom-made time-reporting, expense reporting, task lists, calendars schedules etc.
You can read more at
We are not selling SpreadsheetServer at this time but a new version will be released for sale in 2009.
You can see a simple demo on how to do store the submitted data into an MS Access database using Frontpage at
(I am sorry, there are no comments in the movie, but you can single step forwards.)
You get the full source of the JSP-page and the JavaBeans. It is easy to add your specific code to the JSP-apge to save/read that data into a database or similar.
If you want to see how the JSP-page and JavaBeans are structured, please study the examples for Java
Use Frontpage extension. You will get a file on your webserver, where each set of answer is a row in the CSV-file.
Yes, but you will have to supply the plumbing to the database yourself, either 1. You just serialize the JavaBeans 2. Or you map each individual input cell to a database column.
Tip: Name the cells in Excel, and those names will be used in the JavaBean.
SpreadsheetConverter creates a standard webform, you can either convert it into an php-file or just set the action of the post to php-script that takes all the parameters and saves them into a database.
If you name the input cells and calculated cells in Excel, then these names will be used in the web form.
You want to store the values from your ASP.NET form into a database and repopopulate the form when the user returns back.