Export Data to formatted text file (like mail merge)

[kknoblauch]

Is there any way to export data from table into a formated message. Just
like using mailmerge with word, but not using word. I need to export
thousands of records and I just want it to create a text file. Word kind of
choked after 600 lines. Is there a seperate tool or anything anyone know's
about? Thanks.

 

[John Nurick]

There are several ways of doing it, including:

- create a query that formats the data the way you want, and export the
query to a text file. This is usually simplest, but it all depends on
just what you are trying to achieve.

- create a report and export that to a text file (this needs care to
avoid field contents being truncated and superfluous blank lines being
inserted, but can be done).

- write VBA code to create a text file laid out just how you want.

- if you are used to formatting text in a scripting language (e.g. Perl,
Python...), use OLE and the DAO library to query the table and write
your own code to format the output.