Writing a formatted textfile (fixed length) for EDI

[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

 

[John Nurick]

Hi Thomas,

The usual way is to use File|Export to export to a text format.This
causes the Text Export wizard to appear, which allows you to create an
export specification for the fixed width file (click the Advanced
button).

Once you have created an export specification, you can then automate the
export process by using DoCmd.TransferText.