amount of sheets available. Certain people were only allowed to view
certain sheets. This was then all interegated with CFGrid until everyone
had completed the nessessary information. Then someone downloads the
spreadsheet which had preprogrammed formulas in the cover worksheet for a
summary. The spreadsheet was then deleted.
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 18:54
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
Hi I'm confused on this one. Did you create a DTS to import from the
uploaded spreadsheet? If so where does the DSN-less connection come into
play?
-----Original Message-----
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 12:14 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
we wanted to do it so that users were able to upload an excel
spreadsheet, which could then be manipulated by other people over a
period of time. At the time of writing there was no way to do it in MX
that appeared to work. So we have a bank of datasources setup in CF
which is then monitored by other code and matched up with ODBC
datasources via CFRegistry
Much much easier (and secure) than installing MS Office on the server
(which has the added problem of being really locked down) and trying to
use COM
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
