I would either use a database type of system that dynamically generates the
tables and what not from a table (you could use MySQL or Postgres or
whatever). To edit it, you could use Excel and Access combined somehow and
set up an ODBC data source to your database server (I think there are
drivers for this sort of thing) and setup Access accordingly. That way,
you could open the table from the database, modify it, and then it would
automatically change online.
I've never actually tried that bit with Access and Excel, but I know it can
Of course, there's a bunch of programming involved there and it's probably
not worth it for simple tasks.
Better idea would be to make one program that will automatically format the
data properly on your end, and then scp it up to the server. If you know
that the program is consistent, it won't require you to check anything.
And then, you can just load the page and see if it looks right.
For windows scp, you can use pscp which can be obtained from
You could make a simple windows batch file to run whatever operations you
want on your source file, and then start scp with the necessary parameters
and tranfer the file on over. All you would need to do really is give it
the source file and your password.
If you need some advice on writing a batch file, I can help you with that
All of that still requires you to (most likely) edit the Excel spreadsheet
and save it as a text file of some sort, but it does cut down a few of the
NERDC Support Desk
[log in to unmask]
On Tue, 21 Jan 2003, Kristiina Butler wrote:
> Is anyone familiar with spreadsheets and the web enough to tell me if
> there is a way to dynamically update your spreadsheets. I need to find a
> way to update them quickly without first editing the Excel spreadsheet,
> then saving in the right format, then ftp'ing the file to the web, then
> editing the file to make sure that it's in the right format etc.
> Any advice will be greatly appreciated.
> Kristiina Butler
> Network Services