You'll probably not want to tackle this with ColdFusion. Use a transformation tool native to your DB if it's truly 'massive'. This will give you the most integrity/performance.
If you want to automate the process using ColdFusion, that would be fine. Have them upload the Excel spreadsheet via CFFILE, and then have CF fire a StoredProcedure on your DB to import the information properly from Excel. You could pass the Stored Procedure the excel file name and make it truly dynamic/automated. Adam. > -----Original Message----- > From: Chad [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 9: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. > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
