Copy 6 text files into a text file

[nina1]

I set up six exports macros with the specs to export six queries into six text files. Now I would like to create a macro that will copy each six files into one file.
Can somebody help me with a sample.

Thanks very much!

 

[longhair]

nina1,
you can do it with a simple .bat file:

@echo on
chdir c:\inbound\individual\df\temp
copy DFDATA_EDI.RCC0902 + DFDATA_EDI.RCC0903 + DFDATA_EDI.RCC0904 + DFDATA_EDI.RCC0906 + DFDATA_EDI.RCC00909 + DFDATA_EDI.RCC00910 + DFDATA_EDI.RCC0911 DFDATA_EDI.TMP

this places the contents of the first 7 files into the last file (DFDATA_EDI.TMP).
if i remember correct access does have the ability to execute shell commands.
hth
regards,
longhair