How about this as a solution:
Create an access datasource with an external link to an Excel spreadsheet.
Then write a CF template that allows the spreadshhet to be uploaded,
overwrites the existing file (one nice side of this technique is the Excel
file is not locked like the Access file), and then runs a query that either
appends, or updates the table accordingly. After this process is complete
the Excel file is not used until the next time one is uploaded.
Terry Troxel
----- Original Message -----
From: ramesh deva <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, January 13, 2001 3:23 AM
Subject: how to retrieve excel data and to put into DB
> Hi all,
>
> How can you retrieve the excel sheet data and to put
> in to database..
>
> Is there any tag avaialble,,
>
> Thanx in advace
> Ramesh
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
