[AccessD] Export Queries to Text file

Hi Jim and Reuben

I do and would do it this way. Easy to control and very fast.
The union query could work but it will not be faster and you will have to be careful with sorting.

/gustav

>>> reuben at gfconsultants.com 28-12-2005 20:20:06 >>>
In one function...

1.  Open the text file
2.  Create a recordset of the header query and write that record to the text file
3.  Create a recordset of the detail query and write those records to the text file
3.  Create a recordset of the footer query and write that record to the text file
4.  Close text file

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
> Sent: Wednesday, December 28, 2005 1:57 PM
> To: AccessD
> Subject: [AccessD] Export Queries to Text file
>
>
> I have three queries I need to export to ONE plain text file to be sent
> to one of our benefit providers.
>
> Each query is exactly 1000 characters in width.
>
> The first query has header information, the second is the details, and
> the third is totals and other data.
>
> Currently, we're exporting each query then putting them together.
>
> How do you stack query results into a single text file?