Microsoft KB Archive/105551: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 48: Line 48:
This is by design.<br />
This is by design.<br />
<br />
<br />
You can use Microsoft Query, an application included with Microsoft Excel, to retrieve, view, and organize data from a variety of sources. Microsoft Query is not a database application; it is a database &quot;front-end&quot; used to view data from various sources. If you want to bring data from Microsoft Query into Microsoft Excel, you will have to reformat the retrieved data from within Microsoft Excel.
You can use Microsoft Query, an application included with Microsoft Excel, to retrieve, view, and organize data from a variety of sources. Microsoft Query is not a database application; it is a database "front-end" used to view data from various sources. If you want to bring data from Microsoft Query into Microsoft Excel, you will have to reformat the retrieved data from within Microsoft Excel.


</div>
</div>
Line 55: Line 55:
== REFERENCES ==
== REFERENCES ==


&quot;User's Guide,&quot; version 5.0, Chapter 23, &quot;Retrieving Data from Lists and External Databases Using Microsoft Query,&quot; page 449
"User's Guide," version 5.0, Chapter 23, "Retrieving Data from Lists and External Databases Using Microsoft Query," page 449


</div>
</div>

Latest revision as of 09:51, 20 July 2020

Knowledge Base


Formats Not Copied From Microsoft Query

Article ID: 105551

Article Last Modified on 8/15/2005



APPLIES TO

  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Query 2000



This article was previously published under Q105551

Any formatting you apply to data in Microsoft Query will be lost when you copy this data to the Clipboard.

This is by design.

You can use Microsoft Query, an application included with Microsoft Excel, to retrieve, view, and organize data from a variety of sources. Microsoft Query is not a database application; it is a database "front-end" used to view data from various sources. If you want to bring data from Microsoft Query into Microsoft Excel, you will have to reformat the retrieved data from within Microsoft Excel.

REFERENCES

"User's Guide," version 5.0, Chapter 23, "Retrieving Data from Lists and External Databases Using Microsoft Query," page 449


Additional query words: 5.0 XL

Keywords: KB105551