Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102387

From BetaArchive Wiki
Knowledge Base

Works: Converting an Excel Spreadsheet to a Works Database

Article ID: 102387

Article Last Modified on 11/15/2004


  • 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

This article was previously published under Q102387


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.

Additional query words: 2.00 3.00 4.00 4.50 4.50a ss conversion import export converting transferring w_excel spread sheet w_works

Keywords: kbhowto kbinterop kbfaq KB102387