MSAccess query conversion to excel

[John Baker]

I have a MSAccess query which contains some memo fields. I am using Office
links to transfer the data to Excel.
There are about 500 characters in some of the memo fields. All the data is
displayed as expected in the query, but when the data is transferred to
Excel the data in the memo field cells is cut off.

Is there a way to make sure all data from a memo field is transferred to
Excel? ( I would be happy with a limit of even 1000 characters)
Any help greatly appreciated

John Baker

 

[Debra Dalgleish]

In Access, use the TransferSpreadsheet method to send the data, and
specify one of the later Excel versions. You can do this by creating a
macro, or writing some code, e.g.:

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

Then, add a button on a form, to run the macro or the code.