Microsoft KB Archive/116077

= Works:Transferring Files Between Works for Windows and MS FoxPro =

Article ID: 116077

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.6 Standard Edition
 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.5b for MS-DOS

-



This article was previously published under Q116077



SUMMARY
This article shows you how to transfer files between Works and Microsoft FoxPro.



Transferring Files from Works for Windows to Foxpro
FoxPro cannot open Works for Windows database (*.WDB) files directly. They must first be saved in the dBASE IV file format (*.DBF), using the following steps:


 * 1) Open the database document you want to transfer to FoxPro in Works.
 * 2) From the File menu, click Save As.
 * 3) From the Save File As Type (Works 2.0 or 3.0) or Save As Type (Works 4.0, 4.5 or 4.5a) drop-down list, click dBASE IV.

NOTE: The file extension should change to DBF.
 * 1) Select the directory in which you want to put the new file.
 * 2) Click OK (Works 2.0 or 3.0) or Save (Works 4.0, 4.5 or 4.5a).

You can now open the database file in FoxPro using the following steps:


 * 1) From the FoxPro File menu, click Open.
 * 2) Select the file saved in the steps above and click OK.

The file will now be open in FoxPro.

Transferring Files from FoxPro to Works for Windows
Works for Windows cannot open FoxPro database (*.DBF) files that contain memo fields directly. They must first be saved in comma or tab-delimited text file format (*.TXT) using the following steps:


 * 1) Open the database document you want to transfer to Works in FoxPro.
 * 2) From the Database menu, click Copy To.
 * 3) From the File Type box, click Delimited By Comma.
 * 4) Type a filename with a .TXT extension in the Name box.
 * 5) Select the directory in which you want to put the new file.
 * 6) Click OK.

You can now open the database file in Works using the following steps:


 * 1) From the File menu in Works, click Open Existing File (Works 2.0 or 3.0) or Open (Works 4.0, 4.5, or 4.5a).
 * 2) From the List Files Of Type (Works 2.0 or 3.0) or Files Of Type (Works 4.0, 4.5, or 4.5a) list, select Text (*.txt).
 * 3) Select the file saved in the steps above and click OK (Works 2.0 or 3.0) or Open (Works 4.0, 4.5, or 4.5a).
 * 4) In the Open File As dialog box, click Database.

The file will now be open in Works. You can save the file into Works database format (*.WDB) if you want to do so.

Additional query words: kbhowto Import Export 2.00 2.00a 2.50a 2.50b 2.50 2.60 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a Transfer Reformat B_DFoxPro B_WFoxPro w_works

Keywords: kbinfo kbinterop KB116077

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.