Works: How to Merge Database and Spreadsheet Files in Works (78702)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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.
  3. 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.
  4. Place the cursor in the first blank record or row of the destination document and click Paste from the Edit menu.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB78702
©2004 Microsoft Corporation. All rights reserved.