Why does Access cut off data strings when exporting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

morningfrost120 - 14 Jul 2005 16:34 GMT

I have done a query in which I combined two text fields and when I try to
export the data to Excel or Word it cuts the data off at 255 characters. How
do I fix this?

Reply to this Message

John Nurick - 14 Jul 2005 19:48 GMT

Unfortunately this is how it works. When you export a query that
contains a calculated or formatted string, it is treated as a text field
and truncated at the 255-character text field limit.

As far as I know the work-rounds are
-export the two fields separately and combine them in the destination
application
-provide a temporary table with a memo field to receive the concatenated
text fields, and use the query to append records to the temporary table.
Then export the temp table.

>I have done a query in which I combined two text fields and when I try to
>export the data to Excel or Word it cuts the data off at 255 characters. How
>do I fix this?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

From the Abbey - 15 Sep 2007 01:46 GMT

I am trying to export an Access report to Word, and my memo field gets
truncated. I have no formatting or calculating on this field. Why would
this happen?

Jeff

> Unfortunately this is how it works. When you export a query that
> contains a calculated or formatted string, it is treated as a text field
[quoted text clipped - 15 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

From the Abbey - 15 Sep 2007 02:32 GMT

Appendix to my previous post:

The text is not truncated at 255 characters, and do not seem to be truncated
at a standard length at all.

> I am trying to export an Access report to Word, and my memo field gets
> truncated. I have no formatting or calculating on this field. Why would
> this happen?
>
> Jeff

Reply to this Message