>- see footer for list info -< Hi All, I have the need to import a tab delimited file, having got over the flash form upload issue (thanks to Andy!) and having converted the file into an array using the following UDF (http://www.cflib.org/udf.cfm?ID=855.) I know have an array containing the column names in the first element of the array and then the appropriate data in the subsequent elements of the array.
My question is this, I need to import the array into the database but the array could contain 10K plus items, whilst I could just cycle through the array performing an insert for each record, I wondered if anyone knew of a more eloquent method of performing the same. Each element of the array contains an ID number and telephone number (which may require further work to convert it to a standardised format, i.e. '441217091345' from something like '709 1345', this can be done either before the import or at the same time. The system is CFMX7 and I am using SQL Server 2000. I am not a DTS guru and as result would prefer if possible to perform this using standard SQL Stored Procedures unless anyone is prepared to guide me through the DTS option. Many Thanks, Lee Fortnam [EMAIL PROTECTED] _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
