Gary Kjos
garykjos at gmail.com
Thu Jun 2 09:27:51 CDT 2011
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