This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a report of survey responses that I want to export to Excel to be sent to a translator but the long responses are cut off at 255 characters.
I've looked at a lot of possible fixes to this around the web but the common answers are to make workarounds with VBA. To basically cut the responses apart and then export each piece or something along those lines.
However, this is not my primary job responsibility and I am new to Access and don't have any experience with VBA so I am having a hard time understanding how to go about doing some of those things.
Does anyone know of a way to solve the Excel truncation issue without using VBA? But by just clicking around and changing settings in Access or Excel? I'd love to find a fix along those lines before investing a lot of time trying to learn VBA.
Thanks!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What happens if you export the data as a text file (.csv - comma separated values)? If that succeeds the csv file can be opened in Excel. Maybe it won't limit the number of characters if you do it that way.
Basically any long text responses were having each line separated into a different stacked cell in a single column instead of having the text wrap in a single cell.
I got around the issue by just exporting the query the form I wanted to export was based on instead of the form itself.
If you use the CSV export there is an Advanced button. Clicking it will let you set up the export so it keeps things readable. How is the file changing the data?
When I try exporting as CSV, the formatting gets completely rearranged and the responses become illegible.
When exporting as .txt and then using Excel's Import Text File wizard, I can actually get it all looking ok and not cut off, but instead of having the text wrap, I get three or four cells in a column with the text split between them. This makes it all legible for sure, but because of the way the translators do their job the text needs to all be in one cell per response.