Export truncates field of "memo" datatype.

[mathewbutler]

Access 2000 SR-1

I've spent some time investigating this, and researching both here and
on the MS support site. Briefly;

Problem Description:
-------------------------------
I have the following query which I am using to export data into CSV
format;

SELECT reference, referenceseq, raisedby, raisedfunction, raiseddate,
investby, investfunction, investdate, len(description _rec) AS desc_len,
description_rec AS description
FROM [SELECT part1.Reference , part1.Reference Seq, part1.RaisedBy,
part1.RaisedFun ction, part1.RaisedDat e, part1.InvestBy,
part1.InvestFun ction, part1.InvestDat e, description & '||' as
description_rec
FROM part1
]. AS mig_part1;

In the resulting CVS file I am finding that the "descriptio n" ( of
"memo" datatype) column is being trucated.

Investigation
-----------------
* The full text is visible from the query within MS Access.
* The full text is truncated when exported to CSV
* The full text is NOT truncated when exported to html

The view from this group seems to be that the export tool is formatting
the query and

* Research suggests that export is treating the column as "test" and
there is some mechanism for formatting the field within the export
specification, so that export is expecting a "memo" based field.

Questions:
---------------
* Anyone else experienced this?
* Is there a workaround?
* How do I configure export to process the complete "memo" field?

Thanks in advance