I agree with Dan, look at this;
http://allaire.com/Handlers/index.cfm?ID=1540&Method=Full
http://support.microsoft.com/support/kb/articles/q174/4/96.asp
CFGirl
>From: "Dan Phillips" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Excel as a datasource .... ?
>Date: Wed, 05 Sep 2001 11:15:13 -0400
>
>I agree. Down the road it's going to be a nightmare especially if you have
>server issues now. Sure for a month or two it would be ok but as that excel
>file gets bigger and bigger you will run into trouble. Excel and Access are
>just not meant for high traffic web sites. We don't charge people more to
>use access but we make them keep the file below 20MB in size and we do not
>allow Excel datasources. There is a small memory leak in Access that can
>cause long term problems. I've never used Excel myself as a datasource but
>I
>can only assume you would get the same results. IMHO, Access and Excel are
>good for desktop apps only. I mean, I could eat of off a frisbee instead of
>a plate and it would work but that doesn't mean I should do it.
>
>Just my $0.02
>
>Dan Phillips
>CFXHosting.com
>
>-----Original Message-----
>From: Alex [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, September 05, 2001 10:04 AM
>To: CF-Talk
>Subject: Re: Excel as a datasource .... ?
>
>
>excel as a datasource would make maintainability, scalability, and
>enhancements alot harder and in the long run cost more. Actually, at one
>place I worked at we charged more if the client wanted to use Access over
>SQLServer (I assume excel as a datasource would cost even more).
>
>
>On Wed, 5 Sep 2001, Mike Kear wrote:
>
> >
> > I have a client who's complaining that the time spent generating a small
>app
> > using SQL is costing too much and wants to use excel spreadsheets
>instead.
> >
> > What's your experience using excel as a datasource?
> >
> > Just to clarify what the projects do, they don't write to the
>datasource,
> > just look up and filter the data customising tables for the user's
>needs.
> > The volumes aren't great - between a few hundred page views a month to
>5000
> > or so.
> >
> > IS there likely to be implications for the usage of RAM and resources on
>the
> > server? The System Admin is already complaining that he has to restart
>the
> > server too often and when the processor usage gets to 100% he panics and
> > complains.
> >
> >
> > Cheers,
> > Mike Kear
> > Windsor, NSW, Australia
> > AFP WebWorks
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
