Chad, DTS will allow you to import from a .CSV. To dummy proof it use the "column transformations" tool in the package designer and write little validation routines in VB script. The little IDE makes it pretty easy. You can validate for length, numeric, date etc. (the date validation is tricky). I've always liked this approach rather than CF for file import. CF is ok if you have a limited number of rows, but long running HTTP requests are not usually the way to go - my .02.
-mk -----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. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
