Article ID: 178743 - View products that this article applies to.
This article was previously published under Q178743
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
When you export a query that contains an expression that results in more than 255 characters, the expression is truncated in the exported file.
Microsoft Access evaluates the expression as a Text field, and Text fields have a maximum length of 255 characters. When you export the query, Microsoft Access truncates anything after the 255th character.
Use an append query to append the data to a table containing a Memo field, and then export the table. The following example creates a table to store the results of a query expression that exceeds 255 characters:
Steps to Reproduce Behavior
For more information about exporting data, search the Help Index for "exporting data," or ask the Microsoft Access 97 Office Assistant.