yes. You can even do this 1) have user upload cvs file 2) use sqlloader called via cfexecute to load the data into the DB
This will require installing the oracle client on the server and some patience :) DK On 9/6/06, Joseph Lamoree <[EMAIL PROTECTED]> wrote: > > On 6 Sep 2006, at 11:19, Chris Tilley wrote: > > > Does anyone have a tested method of uploading bulk data to a > > database? I > > have a need (annually) for the admin person to be able to take data > > from an > > Excel spreadsheet and have it inserted into an Oracle database. > > Any sample > > code would be greatly appreciated. I've played with a CFC that > > makes Java > > calls but without success. > > You'll probably get the best performance using the Oracle SQL*Plus > tools, specifically SQL*Loader: > http://www.orafaq.com/faq/sql_loader > > -- > Joseph Lamoree > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
