Export Access Table with Memo Field to Excel

[Josie]

Hi All

Am trying to export data from a Access 2002 table to Excel using:

DoCmd.OutputTo acOutputTable, "RangeDb", acFormatXLS,
"C:\Temp\Range.xls", False

What I am noticing is that the the data held in a memo field is truncated to
255 characters.

Any advice on how to correct this problem would be appreciated.

Josie

 

[John Nurick]

Hi Josie,

See http://allenbrowne.com/ser-63.html for possible causes and
work-rounds.

 

[Josie]

John

Many thanks for your help that helped a lot.

Josie