I have a Long Text field called EbayDescription which can contain up to around 30k characters of html (always under 32k)
When I try to export using External Data > Export to external spreadsheet this field get truncated to just under 4k characters.
It isn't an exact number as record 1 gets truncated after 3,987 characters (it should have 25,882 characters) and record 2 gets truncated after 3,886 characters (it should have 4,940 characters)
I can't see anything in common twith the two cut off points. I get the same problem if I right click the table or query and try exporting from there.
Exporting as a text file isn't an option as although it does export all the content, format is lost as my content contains line breaks.
It will also export okay as an rtf file but again I can't convert that to an Excel file without issue.
I've searched quite a bit on this but most of the truncating problems refer to a 255 character limit.
I'm hoping that someone can shed some light on this for me.
I'm using Access 2013 and do everything with queries and have never used vba or sql
When I try to export using External Data > Export to external spreadsheet this field get truncated to just under 4k characters.
It isn't an exact number as record 1 gets truncated after 3,987 characters (it should have 25,882 characters) and record 2 gets truncated after 3,886 characters (it should have 4,940 characters)
I can't see anything in common twith the two cut off points. I get the same problem if I right click the table or query and try exporting from there.
Exporting as a text file isn't an option as although it does export all the content, format is lost as my content contains line breaks.
It will also export okay as an rtf file but again I can't convert that to an Excel file without issue.
I've searched quite a bit on this but most of the truncating problems refer to a 255 character limit.
I'm hoping that someone can shed some light on this for me.
I'm using Access 2013 and do everything with queries and have never used vba or sql