How do I generate an ASCII report from access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to generate a report from an Access databse (for banking purposes).
Can anyone help/point me in the right direction?
 
See help on:
OutputTo
or if you want to set it as an email:
SendObject

Outputting a report like that can result in blank rows, and headings that
interrupt the flow of data into somewhere else, so it might be better to
use:
TransferText
on the table or query that feeds your report.
 
Thanks - can these be used directly from the query? ie rather than generate
a report from a query output the results of the query to an ASCII file?
 
Thanks - can these be used directly from the query? ie rather than generate
a report from a query output the results of the query to an ASCII file?
 
Sure. You can open the query (in datasheet view) and choose Export on the
File menu.

Or create a macro with the TransferText action if you want to do it from a
command button.
 
Back
Top