Works 2000: Cannot Copy an Entire Database Column to a Spreadsheet (239351)

SYMPTOMS

When you copy a column of data in a Microsoft Works 2000 Database by clicking the field name cell (the whole column is automatically selected), and then clicking Copy on the Edit menu, and you then attempt to paste the column into a Works 2000 Spreadsheet column or cell, the following error message may appear:

The Clipboard contents cannot be pasted here.

Make sure the destination area is as large as the information you want to paste, or select only a single cell where you want to paste.

CAUSE

This behavior can occur because the Works 2000 Database can support 32,000 rows and the Works 2000 Spreadsheet can only support 16,384 rows. When you click the field name cell on the Database, you automatically select every row in the Database, even if there is no data in the row.

WORKAROUND

To work around this issue, select and copy only the cells in the Database that you want to paste into a Works 2000 Speadsheet. To illustrate this, follow these steps:

Start the Works 2000 Database, and then create a blank database.
On the Create Database dialog box, in the Field name box, type DATA.
Click Add, and then click Done.

Create the following database in the DATA field:

   1: Apple
   2: Pear
   3: Peach
   4: Orange
   5: Banana

Select cells 1 through 5 in the DATA field.
On the Edit menu, click Copy.
Start the Works 2000 Spreadsheet.
Select cell A:1.
On the Edit menu, click Paste. The Database is successfully copied.

Works 2000: Cannot Copy an Entire Database Column to a Spreadsheet (239351)

SYMPTOMS

CAUSE

WORKAROUND

STATUS