Need direction on how to edit a spreadsheet or table via a webpage.

[nebula]

What I have currently is a Excel spreadsheet that I update often both at home and at work. Making sure I always have the updated version is a pain, I forget if I emailed the file home for instance. What I want to do is store the file on my server and be to update it via the web. What type of technology should I look into to accomplish this?

I have a commercial web server/space (telnap).
I have access to Visual Basic6 and .NET 2003, Dreamweaver and can probably get ahold of anything I need to do this.

The file doesn't have to stay in Excel format but I do need to have 4 columns and a few hundred rows for data. It would be nice if it were searchable and sortable.

Suggestions are welcome!

 

[ttown]

my first thought is asp.net

i'm just learning it myself, so I'm not much help --- but i'm sure there's others here that could wip out an example

 

[nebula]

I did some brief Googling, what about mySQL and PHP?

I'll look into ASPs capabilities, thanks!

 

[Cheetah8799]

If you want to have a database with web interface, then PHP/MySQL is great. You won't be able to easily export it into a format to send other people though, like if you sent your Excel spreadsheet out.

You could simply do something like a MySQL database and phpMyAdmin for the GUI. phpMyAdmin is meant for a DBA to create/modify databases, not for an application front-end, but it could do what you are asking.

 

[nebula]

I usually only share it with one or two other people and they could just view it on the web, and that's rare. Exportability may be nice once and a while but only for personal use. So if I could get a CSV file out from the db, that would be fine.

Cheetah - Any sites where I could start looking at that option? How/where do I start?