Microsoft KB Archive/163108

= Works: How to Import and Export Works Databases to Excel 97 =

Article ID: 163108

Article Last Modified on 11/24/2003

-

APPLIES TO


 * Microsoft Works 4.5a
 * Microsoft Excel 97 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q163108



SUMMARY
This article discusses how to convert database documents between the versions of Works listed at the beginning of this article and Microsoft Excel 97.

For information on how to convert a Works for Windows database to Access 97, please refer to the following Knowledge Base article:

154167 How to Import a Works Database into Access



To Convert a Works for Windows Database to Excel 97

 * 1) Open the database in Works for Windows.
 * 2) On the File menu click Save As.
 * 3) Under Save File Format, click dBASE IV.
 * 4) Click Save.
 * 5) Start Excel 97.
 * 6) On the File menu, click Open.
 * 7) Under Files of Type, click dBase Files.
 * 8) Locate the file you exported from Works and click Open.

NOTE: When you save in dBASE format, field names will be truncated at 10 characters, so ensure the first 10 characters of each field name are unique.

To Convert an Excel 97 Worksheet to a Works for Windows Database
 Open the worksheet in Excel 97. On the File menu click Save As. Under Save As Type, click DBF 4(dBASE IV). Click Save. Start Works for Windows. Works version 4.0, 4.0a, 4.5 and 4.5a:

On the Works Task Launcher click the Existing Documents tab then click Open a document not listed here.

Works for Windows version 3.0x:

In the Startup window click Open An Existing Document.

 Under Files Of Type click dBASE (*.dbf).</li> Locate your document then click Open or OK.</li></ol>

NOTE: The document will open into a Works database in Form view. To change the view, click List on the View menu.

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works conversion importing exporting converting

Keywords: kbhowto kbfaq KB163108

-

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

© Microsoft Corporation. All rights reserved.