Export not exporting all text into excel

[Steven.Ashby82]

I have a field set to Memo and when I try and export my report to excel it only copies a set amount of text. Is there a way to export everything within the field?

 

[Alansidman]

Memo fields in Access can hold about 18,000 characters. Excel cells can only hold 255 characters. This may be your issue.

 

[ToddNYC]

After spending days with scripts and work-arounds, I found a very easy solution to this access/excel problem.

Download OpenOffice (it's free!) and use Calc, the spreadsheet program. It offers most of the same functionality as Excel with out many of the problems. It may easily solve your problem too. Good luck!