asked on

Adding header and footer rows to a text file from Access 97

I'm posting this question again since I didn't get any response previously and am up against the wall for a solution.

I need to create an external, fixed length text file containing both a header and footer. All 3 files must conform to a fixed file format (starting location, ending location and length)

I have 3 tables with the necessary info to accomplish this from which I create 3 seperate text files.

Creating the files is not my problem. Appending (inserting) the header and footer files into the main file is.

If anyone could share the correct syntax to do this it will be greatly appreciated.

Of course, if anyone has a better idea of how to do this I welcome that input as well.

shanesuebsahakarn

Have a look at Nico's solution here:
https://www.experts-exchange.com/questions/20531062/Exporting-to-fixed-width-text-file.html

Nosterdamus

Hi SERVTRKR,

You can accomplish this with Windows command line as follows:

copy HeaderTextFileName+MainTextFileName+FooterTextFileName OutputTextFileName

Please notice that there are no spaces between the file name and the plus (+) sign.

HTH,

Nosterdamus

SERVTRKR

ASKER

Nosterdamus: Could you be more specific. I now have 3 files (HeadertextFileName, MaintextFileName, FooterTextFileName). Are you saying the user would go to what used to be the old DOS prompt and key in this command? Is there not a way to do the completely from Access?

ASKER CERTIFIED SOLUTION

Nosterdamus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SERVTRKR

ASKER

Thanks for the help.

Nosterdamus

Hi SERVTRKR,

Glad I could help & good luck with your app.

:-)

Nosterdamus