Export Fixed Width txt File with dynamic header and footer

[craig1988]

Hi all



I am looking for the best way to export a query to a fixed width txt file that Will always have a dynamic Header and Footer.

The header and footer will pull data from textboxes on a form.

The only option I had looked into was to export 3 txt files and concatenate them with Command Prompt but the I do not have access to this function on my computer.

Thanks

Craig

[June7]

The only way I know to dynamically set header and footer of text file is to open text file object in VBA and write one line at a time.

Bing: VBA read write text file
http://www.tek-tips.com/faqs.cfm?fid=3767
http://www.excel-easy.com/vba/exampl...text-file.html

However, VBA can invoke the operating system Shell but I don't know if that can do your 'command prompt' approach. What would be the command to concatenate text files?

[craig1988]

Hi June7

Thanks for the pointers!!

http://www.access-programmers.co.uk/forums/showthread.php?t=168031

I am going to try this method...

It seems wasy to follow and avoid using any Cmd Prompts.

You were correct in saying that you would have to write one line at a time.

<header>
<table based on a query>
<footer>

I might even try testing this before the holidays!!

Thanks