Microsoft KB Archive/30661

Word: “Data Record Too Long” with Imported Database File PSS ID Number: Q30661 Article last modified on 08-03-1993 PSS database name: M_WorD

3.00 3.01 3.02

MACINTOSH

Summary:

The error message “Data record too long” may occur when a data document is imported from another application (for example, Microsoft Works) that uses tabs for field delimiters but does not surround fields containing commas with quotation marks. Fields for a Word print merge that include commas must have quotation marks around them or Word will read the comma as a field separator.

Note: This problem does not occur with Word versions 4.0 and 5.0. Data documents with fields separated by tabs ignore commas within those fields.

More Information:

To work around this problem in Word 3.0x, enclose all fields in the Word data document with quotation marks by doing the following:


 * 1) Select the entire document by pressing COMMAND+OPTION+M.
 * 2) From the Search menu, choose Change.
 * 3) Type ^t in the Find What box and “^t” (with quotation marks) in the Change To box.
 * 4) Click Change Selection.
 * 5) Type ^p in the Find What box and “^p” (with quotation marks) in the Change To box.
 * 6) Click Change Selection.
 * 7) When the change is complete, click Cancel.
 * 8) Select the first record (the header record) of the data document.
 * 9) From the Search menu, choose Change.
 * 10) Type a double quotation mark (&quot;) in the Find What box and clear the Change To box.
 * 11) Click Change Selection.

Additional reference words: mswdmerge 3.0 3.00 3.01 3.02

Copyright Microsoft Corporation 1993.