Hi

I am trying to export an Access table to a fixed-width text file. The
table contains 2 memo fields of approx. 1000 characters each.

I am using the 'Export text wizard' to export. In this wizard I change
the default width (512) of the memo fields to the required larger
size but it still only exports as 512.

This has always worked fine for me in Access 2003 but it is truncating
half of the memo field in Access 2007.

Any ideas on how I get around this?

Thanks in advance for any help
Max Kelly