I don't speak the Access, but Debra Dalgleish once posted this:

Or, transfer the data with code. Use the TransferSpreadsheet method to
send the data, and specify one of the later Excel versions:

'======================
Sub SendTableToExcel()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "tblCustomers", _
"c:\Data\ExcelExport.xls", True
End Sub
'===========================


http://groups.google.co.uk/group/mic...cbe18fd9d6d82b

or

http://snipurl.com/1a01v

Paul W Smith wrote:

I am importing data from an Access DB using a MS query. All work perfectly
apart from the memo fields which contain more the 255 characters of data.
ONly the first 255 characters are imported onto my Excel 2003 worksheet.

Is there any way to import the full contents of a meno field into Excel
using a MS query?

Paul Smith

--

Dave Peterson