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

  • Thread starter Thread starter Thomas Marko
  • Start date Start date
T

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
 
Thomas said:
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?
Click to expand...

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.
 
Back
Top