Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text clipped when export to excel
- Thread starter ryDen
- Start date
Not about 255 words, exactly 255 words.
Once the export is complete you can re-open the Workbook using automation, cycle through the cells in the workbook and replace the truncated text, then save the amended workbook.
A couple of questions that might help you evaluate this approach:[ol][li]Can you create a single recordset that has all the truncated text? (may not be possible with subreports)[/li][li]Is there some type of key field in the Excel workbook that you can use to identify what record the truncated text belongs to?[/li][/ol]
CMP
Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus
Once the export is complete you can re-open the Workbook using automation, cycle through the cells in the workbook and replace the truncated text, then save the amended workbook.
A couple of questions that might help you evaluate this approach:[ol][li]Can you create a single recordset that has all the truncated text? (may not be possible with subreports)[/li][li]Is there some type of key field in the Excel workbook that you can use to identify what record the truncated text belongs to?[/li][/ol]
CMP
Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus
- Status
Similar threads
- Locked
- Question
- Locked
- Question
