Philip,
Thanks.
regards
D
Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
N.Ireland
Direct +44 (0) 28 9022 7888
Tel +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223
[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com
[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2000 11:29
To: CF-Talk
Subject: RE: Excel Spreadsheets to MS Access via CF
> Does anyone know the best way to get the following result.
>
> We have an Access Database on the server which collects financial data
> via online forms. (Datasource 1)
>
> This is fine fore some of the clients sales people.
> How ever some sales people want to be able to upload a standardised
> Excel spreadsheet to the web server rather than inputing the results
via
> forms.
>
> Choices:
> they upload the database to the server and we find some way of adding
> the contents of each spreadsheet to the database???
>
> We setup a new datasource for every spreadshhet that is uploaded and
> extract the data via CF and pass it to the database using CF.
Insummary
> use CF to both extract the data and insert the data into the database.
> However the client has over 100 sales people. How can we trigger an
> event thet will create a new datasource each time a spreadsheet is
> uploaded.
>
> A heck of an amount of datasources??????
>
> The sales people want to use the forms at that stage to modify 2
> datasources at once so that they can download a spreadsheet version of
> their own sales when finished.
>
> The database information is then used to produce online reports and
> graphs for MGT decision making.
Here's another possible solution;
Use Access to talk to the Excel spreadsheets (setting up a Link table
for
each SS), then you only have one ODBC datasource, also you can replace
the
SS at any time and Access won't mind at all
You should (with some work) be able to make a macro that will create a
Link
table - you'll have to run it from the command line but that shouldn't
be a
problem
Avoid using Excel ODBC as it's horrible!
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
> -----Original Message-----
> From: Daryl Fullerton [mailto:[EMAIL PROTECTED]]
> Sent: 10 December 2000 16:41
> To: CF-Talk
> Subject: Excel Spreadsheets to MS Access via CF
>
>
> Hi,
>
>
> Any ideas????
>
> Cheers
>
> D
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
