easy question concerning VBA for excel

**gibo** · Feb 11, 2005 07:26

I want to have a form where the user enters the data and on the submit action, this info should be updated to a spreadsheet. How do i do this???

**swdev** · Feb 12, 2005 09:25

You have not given enough information to answer this question.

Anyway, this is the database forum

What is processing the form? PHP, ASP, something else?

It may be as simple as writing to / updating a csv file that can be opened by your spreadsheet program.

Definitley more information required

**WebEngineer** · Feb 13, 2005 10:57

Out of curiosity, isn't an Excel spreadsheet simply a flatfile database?

**asterix** · Feb 14, 2005 10:44

Yes, it is, and no, it isn't.

Excel adds all kinds of feature and functions on top of a file format for storing data. Each sheet can be used as a flatfile table.

And if you see each worksheet in the workbook as corresponding to a table, then it is more correct to say Excel workbooks can be used as an ISAM database. It has no relational capability, but then nor does MySQL.