Appending text files

From: softrock (anonymous_at_discussions.microsoft.com)
Date: 06/09/04


Date: Wed, 9 Jun 2004 05:36:03 -0700

Does anyone know how to append text files using VB? I am outputting three text files from SQL Server using DTS. The first file contains header data, the second contains the base data and the third contains trailer data. I need to be able to append the header data at the beginning of the base data and the trailed data on the end. I've never appended text files before and would really appreciate some help. I am using VB6 and SQL Server 2000 on an NT4 box.