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

Brad Marks BradM at blackforestltd.com
Fri Jun 3 13:33:40 CDT 2011


Gary, Robert, Darrell,

Thanks for the help, I appreciate it.

Brad

~~~~~~~~~~~~~~~~~~~~~~~~~~~


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Thursday, June 02, 2011 4:59 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list