How to Export a Query to XLS

From Access

• 1

  Load your Access file containing the query that you want to export to XLS format.

• 2

  Right-click the name of query on the left-hand panel and click "Export." If you don't see queries listed by default, click "All Access Objects" at the top of the left-hand panel and choose "Queries" from the drop-down list.

• 3

  Select "Excel" from the drop-down list. Enter a name for the new XLS file in the box provided, select the file format, and click "OK" to export the information.

From Excel

• 4

  Click the "Data" tab in Excel and navigate to the "Get External Data" menu. Select "From Other Sources" from the list of options.

• 5

  Click "From Microsoft Query" from the drop-down list. A dialog box will appear listing possible sources of queries. Select "MS Access Database" from the list and then press "OK." A "Connecting to data source" dialog box will appear.

• 6

  Find the database from which you want to pull the query in the "Select Database" dialog box, then click "OK." A "Query Wizard" box appears.

• 7

  Select the name of the query that you want to export into Excel from the left-hand box and click the arrow to move it to the box on the right. Click "Next" twice to export the information to your XLS sheet.