TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
It's unlikely anyone here has done this particular combination of steps before,
but I thought I'd ask.
I recently imported an Excel 97 spreadsheet of tabular data into Access 97. I
used an SQL statement in Access to group the data in a report, then published
the report to Word 97 in an RTF file using the native publish function in
Access. However, at the end, some of the fields in the RTF file had data
truncated.
All the table entries in Access 97 were set at 255 characters. In addition, the
truncation seems random. Sometimes it will truncate, sometimes not, and it
doesn't seem to be related to the length of the string/entry. Does anyone have
any ideas or hints?
