[AccessD] Meld 3 Text Files - Urgent

Vlad, 
If you know the names and locations of the files you may be able to shell a copy command to add the three files together.....
i.e. COPY C:\File1.txt + C:\File2.txt + C:\File3.txt C:\FinalFile.txt
Or could you export the three files, then creat a union query to add the files/tables together, then export the union query ?
Paul





Message date : Mar 01 2004, 08:02 AM
>From : "ACTEBS" 
To : "access group" 
Copy to : 
Subject : [AccessD] Meld 3 Text Files - Urgent
Hi Guys,

I have a small project that exports text files (3 of them) in a fixed
width format. Now the company requires that these 3 files be melded into
1 text file only as apparently their import procedure knows when to
import the one file into separate tables at their end.

I have no problem creating the 3 separate text files, but how do you go
about melding these 3 separate files into 1?

Any ideas most welcome...

Regards
Vlad

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime