Dick,
Is there any way of converting the file to tab deliminated after upload
as these sales guys are bound to mess up a simple file export at client
side?
Does it matter that the spreadsheet has multiple sheets??
Cheers
D
-----Original Message-----
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2000 20:04
To: CF-Talk
Subject: Re: Excel Spreadsheets to MS Access via CF
I have done something similar as follows:
export the excel ss to, say a tab delimited file
upload the file via an online form or ftp
add the data to the database via a CF program which:
CFHTTP reads the file into a query
loops through the above query, issues database inserts
HTH
Dick
At 4:41 PM +0000 12/10/00, Daryl Fullerton wrote:
>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
