Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Export More Data

A query lets you select, filter, even combine the fields in a table. How do you get the data from a mighty Access Query into Excel?

 

Try it: Export from a Query

Run a query: CustomerNameSQ.

Go to External Data->Export->Excel.

 

File Name: CustomerNameSQ

Choose the following Export Options:

Export data with formatting and layout.

Open the file after the export is done.

 

Try it: Review the Data in Excel

External Data-> Export ->Excel
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 5.  Presenting and Sharing Data 

  5.4. Export data   5.4.2.  Export data from queries