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

Querying External Data

You can use a program called Microsoft Query, included with Microsoft Excel, to query certain types of external data and bring the query results into an Excel worksheet for further data analysis. If the external data changes, you can see the updated data in the Excel worksheet. In short, importing extracts a copy of the data, while querying links directly to the data.

Note

As with external data you import, when you query external data, you cannot save changes that you make to the data in Excel to the original data source. To make changes to the external data, you need to use the application in which the external data originated.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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