Article ID: 102387
Article Last Modified on 11/15/2004
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
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.
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
