• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 40. Retrieving Data from Externa... > Transferring Data to Excel

Transferring Data to Excel

After you finish selecting, sorting, organizing, and formatting the data in Microsoft Query, you are ready to transfer that data to Excel. If you started Microsoft Query from Excel with the Data, Get External Data command, you can only transfer data to Excel by using the Microsoft Query File, Return Data to Excel command. If you started Microsoft Query directly from the Start menu, you can use the Microsoft Query Edit, Copy or Edit, Copy Special command to copy data from Microsoft Query to the Windows Clipboard; you then use the Edit, Paste or Edit, Paste Special command in Excel or another Windows application to paste the data into that application. Pasting and linking data from other Windows applications also is described in Chapter 39.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint