keepITcool wrote ...

write your own routine using ADO

Something less drastic would be to try and do the export using a query
in the MS Access UI e.g. the following result in no truncation in
Access2003:

To create a new Excel table (workbook and/or range will be
automatically created):

SELECT
MyMemoCol
INTO
[Excel 8.0;Database=C:\TotallyNew.xls;].MyNewTable
FROM
MyTable
;

To create a new Excel table:

INSERT INTO
[Excel 8.0;Database=C:\TotallyNew.xls;].MyExisingTable
(MyExcelColumn)
SELECT
MyMemoCol
FROM
MyTable
;

Jamie.

--