Access, Excel, Front Page and a partidge in a pear tree...

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,

My boss has created a rather complex multisheet Excel
spreadsheet that he wants available online.

No big deal, save as HTML... Did I forget to mention
that he wants what the user entered data to be stored for
later retrieval?

No big deal, just add a sign-in page that queries an
Access database and create a relationship to the username
and data they entered...

OK, NOW it is a big deal. Did I meantion this is a
multisheet Excel spreadsheet with bunches o'
calculations? I can RE-CREATE the spreadsheets as an ASP
page with uh, Dreamweaver MX, and connect to an Access
database quite easily and painlessly, however the "re-
creation" is the problem, duplication of effort, changes,
debugging... you know the drill.

I'll multisheet my pants if there isn't a relatively
simple way to get Excel and Access to share data in a web
environment! Ya' know, both being MS Office products...

What do I need?
-Access
-Excel
-FrontPage?
-FrontPage server extensions?
-A miracle?
-Lots of toilet paper and airfreshner?!

Any and all suggestions are greatly appreciated.

Regards,
Tom
 
1. Normally, when you upload a Excel or Access file to the web server, you
are not running the actual Excel or Access application, you are just
accessing the specific file as a storage container, so you do not have the
ability to access features as would when running the application on your
desktop.

2. Now if the server you are uploading to, supports the Office Server
Extensions or SharePoint Team Services, and each users has the actual
applications install, then they can interact with the storage container
similar to how they would work with it directly on their local machine.

3. Excel is a single user application and so is it's file format, Access is
a multi-user application and is file format support that. So on the web you
really should use Access or MS SQL Server with ASP/VBScript coding to
duplicate the functionality needed.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
So what you are saying is that I need "Lots of toilet
paper and airfreshner?!" :-(

Darn, I was hoping for a magical way to transfer data
from an Excel created web page ("Save as HTML" with "add
interactivity" checked) to an Access database, both being
on the same webserver of course.

It needs to work in a web environment (with or without
Excel) and be multiuser. I REALLY don't want to re-
create the sheets! :-(

Well, the boss did say it was the final version and there
wouldn't be any changes/revisions... what a commodian.

Thanks for the feedback. If anything comes to mind,
please let me know.

TIA,
Tom
 
I am sure you will get some additional replies by end of tomorrow, so before
stocking up on the toilet paper and airfreshner, wait to see if you get some
better solutions/options.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Back
Top