BCP?
> -----Original Message----- > From: Joshua Tipton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 9:38 AM > To: CF-Talk > Subject: RE: Mass Database update > > run it all in a dts package truncate the table and then use bcp to import > the csv file. > > -----Original Message----- > From: Chad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 10:37 AM > To: CF-Talk > Subject: Mass Database update > > > We have a client that wants to drop a database table and replace it with > a new one every once and a while. > > Is there any dummy proof ways of doing this? > > Have them upload a CSV, use CFFILE to loop over the information and > import it? > > The data will start as an Excel table. > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
