need header/trailer record when using export wizard & specs

  • Thread starter Thread starter cm@flowserve
  • Start date Start date
C

cm@flowserve

I have created a fixed-width file using the export wizard and specification.
I have found out that the recipient of this file needs a header/trailer. How
do I accomplish this?
 
I have created a fixed-width file using the export wizard and specification.
I have found out that the recipient of this file needs a header/trailer. How
do I accomplish this?

one way is to write the file yourself... I know that's not the answer
you wanted, but essentially your only other option is to reopen the
exported file in Access, create a new file, append the header info,
read all the data from the source file into the new file, and then
when that's done, add the trailer text and then close the file. If
you look up read and write in the VBA help, you can find how to do it.

Sorry that's not terribly helpful... maybe I should see if I can write
a class to do that...
 
Back
Top