Works: Converting an Excel Spreadsheet to a Works Database (102387)
The information in this article applies to:
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.5
- Microsoft Works for Windows 95, version 4.0 4.5a
- Microsoft Works 2.0
- Microsoft Works 3.0
This article was previously published under Q102387 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:
- 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.
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.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbhowto kbinterop KB102387 |
|---|
|