Creating ASCII Reports

[Bronson C. Elliott]

I have an existing report in Access that I would like to replicate as much
as possible in an ASCII file. It has a few lines and other formatting that
I know won't port over by using the export command. Does anyone know of a
tool that will aid in building ASCII reports using Access? Or is it pretty
much a coding solution?

 

[Allen Browne]

If the data is just rows and columns, TransferText might do.

Alternatively, OutputTo might be helpful.

 

[Bronson C. Elliott]

Allen Browne wrote in

If the data is just rows and columns, TransferText might do.

Alternatively, OutputTo might be helpful.

It mostly is just rows & columns but it does contain a few subreports,
headers, footers, etc.

Any thoughts?

 

[Allen Browne]

One of the things I've done on occasion is to export to text files, and then
concatenate the files together.

The other alternative is to write the file yourself: Open, Print #, etc.

You can sometimes combine the two: write the files, and then read them in
and patch the together precisely as you wish. Depends how far you need to
go.