Microsoft KB Archive/78702

= Works: How to Merge Database and Spreadsheet Files in Works =

Article ID: 78702

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * 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 Q78702



SUMMARY
This article explains how to merge multiple Works Database and/or Spreadsheet files into a single Database and/or Spreadsheet file.



MORE INFORMATION
To merge Database and/or Spreadsheet files in Works for Windows, you must copy the records from one file into the second file, as follows.

NOTE: It is a good idea to save your files and to create a backup of each file before you perform this procedure.


 * 1) Open each file, and click List from the View menu to view the contents of the Database file as a list.
 * 2) Select the records in the Database file or the rows in the Spreadsheet file from which you want to copy.

NOTE: Do not click Select All. If you do, the incoming data will overwrite the data already in the target file. To select all the records and avoid this problem, press CTRL+HOME and then SHIFT+CTRL+END, or manually select the records.
 * 1) Once the records or rows to be copied are selected, click Copy from the Edit menu. This will copy the records into the Clipboard. The number of records or rows that you can fit into the Clipboard at one time will depend on the free memory on your system. You may have to repeat steps 3, 4, and 5 for large files.
 * 2) Place the cursor in the first blank record or row of the destination document and click Paste from the Edit menu.

Additional query words: w_works 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a combine combining adding append

Keywords: kbinfo KB78702

-

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

© Microsoft Corporation. All rights reserved.