Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Cannot Save a Query's Result Set as a Table

XL2000: Cannot Save a Query's Result Set as a Table

View products that this article applies to.

This article was previously published under Q211584

↑ Back to the top

Symptoms

In Microsoft Query 2000, you cannot use the Save As command to save the results of a query as a table.

↑ Back to the top

Cause

This functionality has been removed from Microsoft Query 2000.

NOTE: You can still use the Save As command in Microsoft Query 2000 to save the design of a query.

↑ Back to the top

Workaround

To save your result set in Microsoft Query as a table, first return the data to a worksheet in Microsoft Excel, and then use Microsoft Excel to save the data. To do this, follow these steps:
1.Activate a new worksheet in Microsoft Excel.
2.Point to Get External Data on the Data menu, and click Create New Query.

This starts Microsoft Query.
3.In Microsoft Query, create the query, and then click Return Data to Microsoft Excel on the File menu.
4.Click OK.
5.On the File menu, click Save As. Select the file type in the Save as type list, type the name of the table in the File name box, and then click Save.

↑ Back to the top

More information

In earlier versions of Microsoft Query, you can use the Save As command to save the design (*.qry) or the result set of a query as a table in a database format that you specify.

↑ Back to the top

Keywords: KB211584, kbprb, kbui

↑ Back to the top

Article Info
Article ID : 211584
Revision : 3
Created on : 11/3/2003
Published on : 11/3/2003
Exists online : False
Views : 383