[AccessD] Export Queries to Text file

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?
>
>
>
> Thanks in advance.
>
>
>
> Jim
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>