And if using Oracle you could use SQLLDR. I have the need to do this just with CF and been using a CFC I got off this list for uploading it but still have not found the time to really progress with it.
On Mon, 10 Jan 2005 16:53:15 -0700, Paul Malan <[EMAIL PROTECTED]> wrote: > If you're using SQL Server, you can create a DTS package then call it > from CF. I couldn't believe the difference in speed when I switched > to DTS. (If you need to use CF to validate the incoming data, use DTS > to populate a temp table, CF to pull it out and insert the validated > data into its permanent home. I'd wager still much quicker than using > a loop over cffile contents, though I'd be curious to know if you wind > up trying both...) > > > On Mon, 10 Jan 2005 17:36:09 -0500, Ken <[EMAIL PROTECTED]> wrote: > > Hi. I want to enable the user to upload a csv file, then the data > > should be validated against pre-defined criteria for different columns > > in the csv file. Once that is done, I want to write the validated > > rows from the csv file to the DB. > > > > Please help. > > > > Thanks, > > Ken > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189881 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
