I am going to have to import a fixed length text file into a database. It will be scheduled to happen everyday in the AM. The file could be around 7 or more megs. I have CF 5 on its own box and a SQL 2000 on another.
This is what I thought I should do. I will dump the table of the previous days info, open the file with CF and some how loop over its contents and insert into the table. Should I even attempt to do this with CF or see if there is something in SQL 2000 that could handle it better/faster? Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists