Export Access tables to CSV file - records need to have varying record lengths

[tbclbd]

What code will "flag"end of record in an access memo field?

I have to create a csv file that contains 8 different record layouts from data in Access tables. In the header record, the record length is 61, while in the next record, the record length is 121, etc. I created an Access table with one memo field, had to use a memo field because some of the layouts, the length is greater than 255.

When I export the access table to csv, the record length in all records is 1271, which is the longest record.

Any help is appreciated.

 

[Darrylles]

tbclbd

What method are you using to 'export' this data.

Please post your code (don't forget

to format it).

ATB,

Darrylle