Dynamically Created Tables that Can be updated and Stored in Access Memo Fields

[cosmodango]

I am working on a form with the basic textboxes, dropdowns, etc.; however, I have a need for the client side to have the option to create a table dynamically in the form. In essence, Joe User would determine rows and columns and then enter values into the the table. This information would then be stored in an Access database and would need to be retrieved and displayed as it was inputted by Joe User. Is it possible to build and capture the entire table as a string? Any help would be greatly appreciated. Would this be easier using the Datagrid function in asp.net?

Thanks in advance for any help.

[jhardman]

I think this would be totally do-able, remember that an HTML table is constructed entirely as a string, as is a .csv file (plain text database). The tricky part is how to make a user enter data in this format. Probably the most straight-forward method would be to make a grid of text inputs, then on the form handler, interpret each of these as a HTML cell <td>, and each new row as a new <tr>, then concatenate them into one long string. Then this would be easily pulled up onto new web pages, since you already interpreted it as HTML.

On the other hand, csv files are also very well supported, and any spreadsheet can open them easily. If you wanted to make a csv file (the downside is a comma is a special character) you just need to separate each cell with a comma and each row with key word "vbNewLine". Let me know if this helps.

Jared