Microsoft KB Archive/44122

Word: Creating a Print Merge Document from dBASE III PLUS

PSS ID Number: Q44122 Article last modified on 11-02-1994

2.x 3.x 4.00 5.00 5.50 6.00

MS-DOS

= SUMMARY =

Ashton-Tate’s dBASE III PLUS provides a delimited output-file format that can be used as a data document for the Print Merge command in Microsoft Word. From the dBASE dot prompt, enter the following commands:

USE filename COPY TO data.doc TYPE DELIMITED

= MORE INFORMATION =

The following characteristics define the structure of a delimited file created by dBASE:


 * 1) Each record is on a line of its own, ending with a carriage return and linefeed character.
 * 2) Inside a record, each field is separated from the next by a comma.
 * 3) Character fields are enclosed in quotation marks (the default delimiter), and trailing blanks are not included in string values.

This file can be loaded into Word and a header record inserted at the top that includes a name for each of the fields in the data record.

-or-

A Separate header file can be created. Enter the field names in the same order as the fields in the data document.

Note: When the dBASE file is copied to a delimited type, fields that were created with the DATE format translate to an eight-digit number, where the first four digits are the year, the next two digits are the month, and the final two digits are the day (for example, “01/19/81” becomes 19810119).

KBCategory: kbother KBSubcategory: kbmerge Additional reference words: ============================================================================= Copyright Microsoft Corporation 1994.