Export Data from Access to Excel

[Guest]

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?

 

[Joseph Meehan]

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?

Length of cell contents (text) 32,767 characters. Only 1,024 display in
a cell; all 32,767 display in the formula bar.


I believe that Access will only export the first 255 characters however.

 

[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.