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:252257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4