Exporting Access memo fields to Excel

[atadbitslow]

When I export an Access 97 report that contains memo fields to Excel 2000, some of the data in the memo fields gets cut-off. It does not only happen on long entries, a few shorter entries were cut off also. I can copy and paste the data, so I know it fits in the cell.....

Any ideas?? Thanks-

 

[dawnd3]

I know that saving reports to excel sometimes has issues. It is usually better to save the query itself to excel or the report to word. I would try saving the underlying query and see if that gives you better results.

Dawn

http://www.calliopeconsulting.net