Works: Converting an Excel Spreadsheet to a Works Database
This article was previously published under Q102387
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.
Excel spreadsheets can be converted to a Works for Windows databaseusing the dBase III or dBase IV file format. To complete thisconversion, 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 ENTER.
- Select the file and choose OK. Works for Windows will convert the file automatically to the Works for Windows database format.
: Each column of your spreadsheet will convert to a field in your database. Each cell in the first row of your spreadsheet will transferas a field name in your database.
2.00 3.00 4.00 4.50 4.50a ss conversion import export converting transferring w_excel spread sheet w_works
Article ID: 102387 - Last Review: 11/15/2004 23:38:29 - 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