Exporting ACCESS Report to Excel format

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?
 
G

Guest

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.
 

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

Export Access Report to Excel keep format 4
Access Report 1
Export to Excel missing text 2
Exporting to Excel looses Report subtotals (footers) 1
Access Export of data to Excel using VBA - data looks awful 4
Extra column in Excel 1
Exporting Access 2000 reports to Excel 3
Export or Import to Excel and Format 4

Top