MsQuery: Cannot Create a Scrap

 Last reviewed: March 27, 1997
Article ID: Q141175
2.00 WINDOWS kbtool kbusage xlquery

The information in this article applies to:

  • Microsoft Query for Windows 95, version 2.0
  • Microsoft Excel for Windows 95, version 7.0

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.

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q138275
   TITLE     : What Is a Scrap (.shs) File?

KBCategory: kbtool kbusage
KBSubcategory: xlquery

Additional reference words: 2.00 7.00 XL7
Keywords : xlquery kbtool kbusage
Version : 2.00
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.