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:
- In the Excel spreadsheet, select the data you want to transfer and choose Set Database from the Data menu.
- From the File menu, choose Save As.
- 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.
- Exit Excel and open Works for Windows.
- From the File menu, choose Open Existing File.
- Change to the directory where the file is located, type
*.DBF in the File Name box, and press
- Select the file and choose OK. Works for Windows will convert
the file automatically to the Works for Windows database
: 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.
Article ID: 102387 - Last Review: November 15, 2004 - Revision: 3.0
- 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
|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.