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

I dont understand what is meant by different record types? I know what field
types are but what is a record type?

Would you consider using queries to create a local table with. The desired
result then export that then import it again into another table with an
import specification ... and compare the two tables. It makes double work
but computers arent paid by the hour anyway. It will prove beyond any doubt
they got the data you think they got plus you have a record of what you
sent.

Bill Benson
Owner
VBACreations, LLC
On Jun 3, 2011 2:36 PM, "Brad Marks" <BradM at blackforestltd.com> wrote:
> 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.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com