update.
the cut and paste is [tab] delimited text - which easy to parse and process.
One case I use it to just add new data, in another I use this approach to
create or update pricing and inventory totals nightly.
Eric
_____
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: September 3, 2004 4:00 PM
To: CF-Talk
Subject: Re: Parse an uploaded excel spreadsheet?
Create and ODBC connection to an excel file. So long as you save the
file as the same name all the time it should work out ok.
Adam
On Fri, 03 Sep 2004 16:51:17 -0400, Mark Murphy
<[EMAIL PROTECTED]> wrote:
> We have an interesting user requirement to be able to download an excel
spreadsheet from one of our systems (a simple data grid-type sheet), make
changes to the xls, and upload it back to the web server to have the records
automatically added/updated/deleted in one operation.
>
> I can envision the CF logic to do the add/update/delete processing, but
before I get that far, how can I get CF to query an uploaded spreadsheet?
Isn't there a way to setup a datasource inline in a cfquery? Or do I have
to mess around with createobject() and have excel installed on the server,
etc? Has anyone done this?
>
> Thanks
> -Mark
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
