MsQuery: Cannot Create a Scrap
ID: Q141175
|
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:
- Select the results from Microsoft Query, then click Copy on the Edit
menu.
- Start Microsoft Excel or Microsoft Word.
- On the Edit menu, click Paste.
If you are using Microsoft Excel, skip to step 6.
- Select the text, then click Convert Text To Table on the Table menu.
- Separate text at Tabs and click OK.
- Select the data, and then click Copy on the Edit menu.
- 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:
Q138275 What Is a Scrap (.shs) File?
Additional query words:
XL7
Keywords : xlquery
Version : 2.00
Platform : WINDOWS
Issue type :