Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC: Exported Query Expression Truncated at 255 Characters
Article ID: 178743 - View products that this article applies to.
This article was previously published under Q178743
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.
Article ID: 178743 - Last Review: January 22, 2007 - Revision: 2.1