Microsoft KB Archive/102387

= Works: Converting an Excel Spreadsheet to a Works Database =

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:


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.