Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Exported Query Expression Truncated at 255 Characters
Article ID: 207668 - View products that this article applies to.
This article was previously published under Q207668
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 that has 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 to text files, click Microsoft Access Help on the Help menu, type export a datasheet to a delimited or fixed-width text file in the Office Assistant or the Answer Wizard, and then click Search to view the topic.