Works: Converting an Excel Spreadsheet to a Works Database

Article translations Article translations
Article ID: 102387 - View products that this article applies to.
This article was previously published under Q102387
Expand all | Collapse all

SUMMARY

Excel spreadsheets can be converted to a Works for Windows database using the dBase III or dBase IV file format. To complete this conversion, do the following:

  1. In the Excel spreadsheet, select the data you want to transfer and choose Set Database from the Data menu.
  2. From the File menu, choose Save As.
  3. Enter a new name for the file, specify the directory in which you want the file saved (for example, C:\MSWORKS) and choose DBF 3 or DBF 4 from the Save File As Type box.
  4. Exit Excel and open Works for Windows.
  5. From the File menu, choose Open Existing File.
  6. Change to the directory where the file is located, type *.DBF in the File Name box, and press ENTER.
  7. Select the file and choose OK. Works for Windows will convert the file automatically to the Works for Windows database format.
NOTE: Each column of your spreadsheet will convert to a field in your database. Each cell in the first row of your spreadsheet will transfer as a field name in your database.

Properties

Article ID: 102387 - Last Review: November 15, 2004 - Revision: 3.0
APPLIES TO
  • Microsoft Works 4.0 Standard Edition
  • Microsoft Works 4.5 Standard Edition
  • Microsoft Works 4.5a
  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 3.0 Standard Edition
Keywords: 
kbfaq kbhowto kbinterop KB102387
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com