Exporting ACCESS Report to Excel format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to send an access report as an excel attachment(as the recipient
does not have MS Access). I went ahead and exported the report to excel and
was successful , however, one of the contents of the fields in the report
got truncated when exported. The field is a memo field.ALl other fields were
exported correctly. What seems to be the problem?
 
The maximum Excel can handle in one cell is 256 characters. Memo fields can
be longer than that and only the first 256 will be exported.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
EXPORT QUery with memo field to excel, truncated data 2
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
Access Export Problem 1
Export to XML - error 31532 0
Export Access Report to Excel keep format 4
Export Access Report to Excel 4
transfer to excel 1

Back
Top