Excel -> Access -> Word

Subject: Excel -> Access -> Word
From: "David Slonosky" <David_Slonosky -at- i2 -dot- com>
To: techwr-l -at- lists -dot- raycomm -dot- com
Date: Mon, 13 Sep 1999 10:43:38 -0400

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

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?


Previous by Author: VBA routine for selecting through a Word table?
Next by Author: FP 98 Publish Workflow
Previous by Thread: HTML vs PDF for online manuals - more details
Next by Thread: Prompt as ask

What this post helpful? Share it with friends and colleagues:

Sponsored Ads