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

Brad,
Another option would be to just create & save a query that converts the
numeric values to strings; eg, using CSTR(), then right-click and export the
query as a text or Excel file. That works if there aren't OLE, blob, or
image types.
HTH,
Darrell

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, June 02, 2011 7:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Question on Creating a Flat File with Access 2007

For multiple record types and lengths, I would use File IO to write the
file.

Longtime AccessD member Seth Galitzer has example code here

http://seth.galitzer.net/node/11

Look for "File IO in VB"

GK

On Wed, Jun 1, 2011 at 4:06 PM, Brad Marks <BradM at blackforestltd.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com