fixed lenght file - 3 separate Specifications

[cm]

I have a database that includes exporting a fixed-length file to send to an
outside vendor. I set up different export Specifications for the header,
footer, and data portions, as the field requirements were different for each.
(this was my first experience using the Specification feature.)

As a result it is necessary to export them separately and them combine the
output files with a text editor. This is fine for my own use, but the end
user now has Access on their machine and I would like to pass the task to
that person.

Does anyone have suggestions on how I might bypass the need to have 3
separate specs or how to combine the output within the application rather
than manually in the text editor?

 

[Jerry Whittle]

copy a.txt+""+b.txt+""+c.txt z.txt

Something like the above will merge the 3 files into one. You could even put
it into a .bat file and run it from Access. You may need the full path names
in there.

 

[cm]

Sorry -- I could use some clarification. Where would this copy command be done?

 

[PieterLinden via AccessMonster.com]

Sorry -- I could use some clarification. Where would this copy command be done?

copy a.txt+""+b.txt+""+c.txt z.txt

[quoted text clipped - 15 lines]

At the DOS prompt.

 

[cm]

this worked great with one exception ---
i copied the header then the data then the footer --- on the line after the
footer there is now what appears to be an 'indent' symbol -- a tiny arrow
pointing to the right in the first space. I have repeated the procedure
several times and keep getting this symbol --- any ideas on what this is or
how to avoid it?


--
cm

Sorry -- I could use some clarification. Where would this copy command be done?

copy a.txt+""+b.txt+""+c.txt z.txt

[quoted text clipped - 15 lines]

separate specs or how to combine the output within the application rather
than manually in the text editor?

At the DOS prompt.