Microsoft KB Archive/92966

{|
 * width="100%"|

HOWTO: Using a FoxPro Database in a Word for Windows Mail Merge

 * }

Q92966

-

The information in this article applies to:


 * Microsoft Visual FoxPro for Windows, versions 3.0, 5.0, 6.0
 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6, 2.6a
 * Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a
 * Microsoft Word for Windows, versions 1.0, 1.1, 1.1a, 2.0, 6.0

-

Information from a Microsoft FoxPro database file can be converted for use in the mail merge feature of Microsoft Word versions 1.x, 2.0, and 6.0 for Windows.

NOTE: Memo fields convert as blank fields. If the data in the memo field is required for the mail merge, you must write a program to convert the data. Only Word versions 1.x and 2.x for Windows require that memo fields be converted.

Word Version 1.x
To convert a FoxPro database for use with a mail merge in Word version 1.x for Windows, issue the following commands in the FoxPro Command window: 

  USE COPY TO TYPE DELIMITED Here is the name of the existing database and is the name of the intermediate format file. FoxPro automatically appends the .DBF extension to the filename.

Word Version 2.0
To convert a FoxPro database for use with a mail merge in Word version 2.0 for Windows, issue the following commands in the FoxPro Command window: 

  USE COPY TO TYPE FOXPLUS where is the name of the existing database and is the name of the intermediate format file. FoxPro automatically appends the .DBF extension to the filename.

Word Version 6.0
In Word version 6.0, you can use ODBC to directly read in the FoxPro database.

NOTE: See Q157767 for information on downloading the ODBC driver for Visual FoxPro.


 * 1) Start Word version 6.0.
 * 2) From the Tools menu, choose Mail Merge. Then choose the Create button under Main Document. Edit your main document as needed.
 * 3) From the Tools menu, choose Mail Merge, choose the Get Data button under Data Source, and then choose Open Data Source.
 * 4) Select &quot;MS FoxPro Files (*.DBF)&quot; from the List Files Of Type box, and then select the FoxPro database.

NOTE: If &quot;MS FoxPro Files (*.DBF)&quot; is not available, you must install the data access (ODBC) utilities using the Word Setup program.