You are currently offline, waiting for your internet to reconnect

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

This article was previously published under Q163108
This article has been archived. It is offered "as is" and will no longer be updated.
This article discusses how to convert database documents between theversions of Works listed at the beginning of this article and MicrosoftExcel 97.

For information on how to convert a Works for Windows database to Access97, 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 areunique.

To Convert an Excel 97 Worksheet to a Works for Windows Database

  1. Open the worksheet in Excel 97.
  2. On the File menu click Save As.
  3. Under Save As Type, click DBF 4(dBASE IV).
  4. Click Save.
  5. Start Works for Windows.
  6. 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.
  7. Under Files Of Type click dBASE (*.dbf).
  8. Locate your document then click Open or OK.
NOTE: The document will open into a Works database in Form view. To change the view, click List on the View menu.
3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works conversion importing exporting converting

Article ID: 163108 - Last Review: 12/04/2015 16:17:49 - Revision: 2.0

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

  • kbnosurvey kbarchive kbfaq kbhowto KB163108