Report in a formatted text file (EDI-Message) out of Access

[Thomas Marko]

Dear Folks

I need to write a formatted (fixed length) textfile
(for an EDI-message) out of an Access-Database.

- Is it possible to do it with the nice report writer
of MS Access?

- If not, do I do it with Access Basis and does somebody
know/have any examples how to do it?

Thank you in advance
Thomas Marko

 

[Marshall Barton]

I need to write a formatted (fixed length) textfile
(for an EDI-message) out of an Access-Database.

- Is it possible to do it with the nice report writer
of MS Access?

- If not, do I do it with Access Basis and does somebody
know/have any examples how to do it?

Reports are graphical, they do not lend themselves to the
limitations of a text file.

Depending on the layout of the data in the report, you may
be able to get away with exporting a query to the text file.
OTOH, you may have to write a fair amount of VBA code that
uses the File I/O statements (Open, Put/Write, etc.