Microsoft KB Archive/142972

= Works: How to Convert a Works Spreadsheet into a Database =

Article ID: 142972

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q142972



SUMMARY
This article describes how to convert a Works Spreadsheet to a Database, or a Database to a Spreadsheet.



Copy and Paste

 * 1) Open the file you want to convert.
 * 2) If the file is a Spreadsheet, click cell A1. If the file is a Database, click in the first field of the first record in List view.
 * 3) Press CTRL+SHIFT+END to select all cells.
 * 4) On the Edit menu, click Copy.
 * 5) On the File menu, click New. In Works versions 2.0 and 3.0 click Create New File.
 * 6) Create a new Spreadsheet or Database. If you create a Spreadsheet, skip step 7.
 * 7) To create a new Database in Works 4.0, 4.0a 4.5 or 4.5a, click Add To A Field, and then click Done. In Works 2.0 or 3.0, click List on the View menu.
 * 8) On the Edit menu, click Paste. In a Works 4.0, 4.0a 4.5 or 4.5a database click Yes to let Works add extra fields.

NOTE: Formulas will not be copied, only the values that are the results of formulas. You must clear the field and re-enter any formulas.

Save the File As Text

 * 1) Open the file you want to convert.
 * 2) On the File menu, click Save As.
 * 3) Enter new file name and add the extension .txt. For example, you could name the file Customers.txt.
 * 4) In Save As Type, click Text & Tabs, and then click OK.

In Works 2.0 and 3.0, this section is called Save File As Type.

NOTE: Saving a file as Text will remove any formulas or applied formatting.
 * 1) On the File menu, click Open. In Works 2.0 and 3.0, click Open Existing File.
 * 2) In Files Of Type, click Text. In Works 2.0 and 3.0 click List Files Of Type.
 * 3) Select the previously saved file and click Open or OK.
 * 4) Click Text For Windows, then click the button for the type of file you want to open it as.

NOTE: Works 4.0, 4.5, or 4.5a will open a text file as a database in Form view. Works 2.0 and 3.0 will open a text file as a database in List view.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a w_works change changing converting

Keywords: kbinfo KB142972

-

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

© Microsoft Corporation. All rights reserved.