In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.
query
An Introduction to YQL for VBA
YQL is a flavor of SQL that allows you to query Yahoo's databases in a simple way. In Yahoo's words:
The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.
Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service.
With YQL, developers can access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.
Get fat with Excel
All of the talk about losing weight after the holidays (see Excel Weight Loss Tracker for one) has me swinging in the other direction. They say that as a result of posting the calorie counts at restaurants (as required here in NYC), people are responding by making more responsible food choices, but I think it's safe to start eating some high fat, high calorie meals again.
Follow Me