I've had good luck using an access database with tables linked to the excel
sheets. This way you can use all the features of access like views etc and
you can swap out the excel file without having to worry about the file being
locked by the cf server.
----- Original Message -----
From: "Mike Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 11:23 AM
Subject: Excel as a datasource .... ?
>
> 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
