Microsoft KB Archive/141175

= Cannot Create a Scrap =

Article ID: 141175

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q141175





SYMPTOMS
You cannot create a scrap when using Microsoft Query.



WORKAROUND
To work around this situation, use the following steps to create the scrap using Microsoft Excel or Microsoft Word:


 * 1) Select the results from Microsoft Query, then click Copy on the Edit menu.
 * 2) Start Microsoft Excel or Microsoft Word.
 * 3) On the Edit menu, click Paste.

If you are using Microsoft Excel, skip to step 6.


 * 1) Select the text, then click Convert Text To Table on the Table menu.
 * 2) Separate text at Tabs and click OK.
 * 3) Select the data, and then click Copy on the Edit menu.
 * 4) Use the right mouse button to click the desktop. On the shortcut menu, click Paste.

NOTE: A Microsoft Excel sheet cannot exceed 16,384 rows by 256 columns; a Microsoft Word table cannot exceed 32,767 rows by 31 columns.



MORE INFORMATION
This behavior is by design. Microsoft Query does not support the drag-and- drop functions for OLE.

A scrap is a file that is created when you copy part of a document and paste it on the desktop.

