Getting External Data into the Workbook
“Sorry. If you do that, you'll void the product warranty.” That's what I was told by a software vendor when I asked him about pointing a query at the overpriced application he'd sold one of my clients.
No software publisher can possibly anticipate all the reasons that a customer might want his product. And that means that publishers can't possibly provide for all the ways that customers might want to view data. So, you'd think that a well-behaved publisher would offer an efficient means for users to get data out of one application and into another.
Some do. The same company that warned me about voiding the warranty later came out with a new, improved product that makes it easy to point queries at its tables. ...
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
