Do you have permissions to execute files? If so you could use Oracle's SQLLDR tool and just trigger it from CF. Pretty certain it will work with a tab as the delimiter.
-- Aaron Rouse http://www.happyhacker.com/ On Tue, 7 Dec 2004 10:14:39 -0600, Schreck, Tom <[EMAIL PROTECTED]> wrote: > > > > What's the best approach to uploading a tab delimited file using ColdFusion? > I'm working in an Oracle environment and I'm new to Oracle. So, for right > now I have to use ColdFusion. I am using <cfhttp> to turn file into a > recordset. I'm looping over the recordset and am doing an insert statement > for each record. This is timing out and seems overkill. Is there a way to > do a bulk insert from a recordset into a table? > > > > Thanks - Tom ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
