ACTEBS
actebs at actebs.com.au
Mon Mar 1 09:38:20 CST 2004
Hey Gustav, Many thanks to you and Paul, got me out of a bind and did the trick... Thanks again Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Monday, 1 March 2004 7:51 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Meld 3 Text Files - Urgent Hi Vlad The quick-n-dirty road is to use Shell and this DOS command: copy file1.txt+file2.txt+file3.txt file.txt If you prefer VBA code and the files are relatively small, you can just open them one by one, read the lines and append them to the new file one by one. As posted many times here, Seth has on his site the basic code for reading and writing text files. /gustav > 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