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
