Export Data from Access to Excel

M

Mary

When I use Office Links to export data from Access to Excel, some of the text
in a memo field is cut off. Is there a limit to the amount of text that can
be exported? Is this an Access issue or an Excel issue?
 
K

Ken Snell [MVP]

Use a macro (TransferSpreadsheet action) or VBA code
(DoCmd.TransferSpreadsheet) to do the export. The File | Export process uses
an old version of EXCEL as the format, and that version won't support text
strings longer than 255 characters.
 
Top