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

Chapter 6. Exhanging Data Annoyances

Chapter 6. Exhanging Data Annoyances

Excel usually plays nice with other programs—but when something goes wrong, it goes really wrong. One troublesome area is getting data from external sources, such as databases. Sure, it's easy to cut-and-paste from Access to Excel, but that's a sledgehammer approach where you might need a little finesse. For example, what if you only want to find the addresses of customers from Oregon who placed an order in the last month? That's the sort of thing that's difficult to do with Excel's built-in tools, but it's easy if you use Microsoft Query, an Office utility designed to get data out of databases, text files, and other data sources. You'll learn how to use Query to solve this and other conundrums, tap into SQL to get data, and also make Excel make nice when exporting data to the Web.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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