Adding header and footer in Table

[drunkenneo]

I have a single column table which is created by set of queries, the data type is of memo, the single column table is a merge of a table with multiple columns by adding a space between the columns.



This table is then exported to the txt file, i want to add header and footer which appears exactly on the position after exporting as of now the header and footer is occuring in between the table data.

Please help.

[June7]

How are you exporting to txt file that causes header and footer between table data? What method are you using to export?

[drunkenneo]

DoCmd.TransferText acExportFixed, "Final Export Specification", "FINAL", CurrentProject.Path & "\mmdd01.txt", False

I am inserting the header and footer by an insert query.

[June7]

Don't see anything wrong with that code. Perhaps issue is with the insert query. Would have to review. If you want to provide db for analysis, follow instructions at bottom of my post.

[drunkenneo]

Big Mess for making a copy and attache it

[drunkenneo]

I am using transfer text only

The reason of heaader and footer coming in middle is , before inserting in the table i am inserting header and footer and then rest of the Data.

Due to which the header and footer goes in between, and when tranfer text command is clicked it transfers only as a stored table.

The only chump here is i am inserting header and footer as normal table record, which the table fails to order. I am thinking to fix the order of header to top while in insert query and the footer on bottom which wil solve my problem, how to do it?

[June7]

Records in tables don't have a set order. A table is like a bucket with a bunch of coins tossed in. You can't depend on the 'header' record to be first and the 'footer' record to be last. Defining record order requires a query with sort criteria.

Your options:

1. export the table to Excel and create header and footer rows then save as text file.

2. use VBA to open a text file object and write records to the text object, one line at a time.

3. export a report to text file