Forum Discussion
03 Access output to Excel truncates data
When exporting to older Excel formats (Excel 97-Excel 2003 or older), we export a maximum of 255 characters.
When exporting to current Excel formats, we export more than 13000 characters.
When using the Excel button from Report Print Preview, we only give you the option to export to the older formats (because the code for exporting reports was never updated for the newer Excel formats, only the code for exporting tables)
So, I’m not sure how you get the case where we are exporting >255, but <15000 characters.
If you can give me a database that shows what you are seeing, and information about version/build of Office, I can look further.
If not then you may be able to get around this by exporting directly from the table data instead.
Hi Maria,
Thank you for you help - there was a bit of back and forth last week internally within the regulatory group regarding sending you a db with the example of the issue ie, " If you can give me a database that shows what you are seeing, and information about version/build of Office, I can look further. ".
I am not sure how they want to proceed at this time.
I am suggestioning a bare-bones db with just the problem record and output as a test case.
I hope to get back with something mid-week.
Thanks!
Best Regards,
Donald
Hi Maria,
Thank you for your patience.
We have put together a working test case build that demonstrates the truncation issue.
It is attached as "truncation_for_description_field.zip"
Below are screenshots (also in zip file) that step one through the process from opening up the db to exporting the report to excel to show the truncation.
Best Regards, DonaldDonaldCollins Perfect, will pass this on!
MariaBarnes
Hi Maria,
Hope all is well.
Has there been any feedback from the MS team about the test case and issue?
Thanks!
Best Regards,
Donald