Right tool for the job. Doesn't SQL Server have this import capability? On Mon, 29 Jul 2002, Phillip B wrote:
> 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