Microsoft KB Archive/102387

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:02, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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