"Matt Slattery" wrote ...

I am using ADODB recordsets and Late Binding Object
Automation to export data from Access to Excel. One of the
fields in this recordset is a memo field which will often
have more than 255 characters. Due to the Automation
Object limitations - only the first 255 character will be
inserted into Excel.

Why are you using automation at all? You don't even need a recordset
(but may want to use one if you are operating on an open workbook).

e.g. to create a new Excel table (and worksheet/workbook if
necessary):

SELECT
MyMemoCol
INTO
[Excel 8.0;HDR=YES;Database=C:\MyJetDB.mdb.].NewExcelTable
FROM
[Database=C:\MyJetDB.mdb.].MyTable
;

e.g. to append to an existing Excel table:

INSERT INTO
[Excel 8.0;HDR=YES;Database=C:\MyJetDB.mdb.].[MyExcelTable]
(MyExcelCol)
SELECT
MyMemoCol AS MyExcelCol
FROM
[Database=C:\MyJetDB.mdb.].MyTable
;

If using an existing table, you need to ensure the relevant column is
'seen' by Jet as ype 'Memo'. For details, see:

http://www.dicks-blog.com/excel/2004...al_data_m.html

If you are using a connection to either the .mdb or the .xls, you can
omit the connection string from the sql text.

Jamie.

--