fixed lenght file - 3 separate Specifications

  • Thread starter Thread starter cm
  • Start date Start date
C

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?
 
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.
 
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


PieterLinden via AccessMonster.com said:
cm said:
Sorry -- I could use some clarification. Where would this copy command be done?
copy a.txt+""+b.txt+""+c.txt z.txt
Click to expand...
[quoted text clipped - 15 lines]
separate specs or how to combine the output within the application rather
than manually in the text editor?
Click to expand...
Click to expand...

At the DOS prompt.
Click to expand...
 
Back
Top