Export Data from Access into a Sequential Flat File Format 1

[StevieB01]

I need to export data into a sequential text file. Does anyone know how of some vba code that would do this?

Eg of file format.

Header Block
Text Block
Trailer Block
Enf of File Block



eg of a File with 2 records.

Header = ddmmccyy
Txn Ref = ABC001
Currency= GBP
Amount = 125.30
Trailer = EOT
Txn Ref = ABC002
Currency= USD
Amount = 99.30
Trailer = EOT
End of File = EOF

 

[RonRepp]

Try forum705. It is specifically for Access VBA.

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.