[AccessD] Question on Creating a Flat File with Access 2007

I would use queries to get the data.
Then, I would open a file object and "Print" the lines into it as you need to.
Then close the file.

Robert

At 06:35 PM 6/1/2011, you wrote:
>Date: Wed, 1 Jun 2011 16:06:24 -0500
>From: "Brad Marks" <BradM at blackforestltd.com>
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Subject: [AccessD] Question on Creating a Flat File with Access 2007
>Message-ID:
>         <E9A6E8C998E16F4FB3D861390AFE32C501208F6D at blkltd.blkfst2003.local>
>Content-Type: text/plain;       charset="us-ascii"
>
>We need to create a sequential file to feed to another firm according to
>their specifications.
>
>The specs call for several different "Record Types".
>
>Each Record Type has a different length.
>
>The source data resides in tables that we are currently reading into
>Access via ODBC.
>
>What is the best way to create this output file with Access?
>
>Thanks,
>Brad

Robert L. Stewart
www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com