Help and Support
 

powered byLive Search

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

Article ID:163108
Last Review:November 24, 2003
Revision:2.0
This article was previously published under Q163108
On This Page

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 (http://support.microsoft.com/kb/154167/EN-US/) How to Import a Works Database into Access

Back to the top

MORE INFORMATION

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.

Back to the top

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.

Back to the top


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

Back to the top

Keywords: 
kbfaq kbhowto KB163108

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.