Hi,
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.
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
