Ashish Mathur wrote:
Hi,

Thank you for sharing this. Is there a source you can guide us to for
learning more on MS Query and the kind of problems it can solve.



One site that comes to mind is Charlie Kyd's ExcelUser. He has a nice
step-by-step demonstration of setting up a query:

http://www.exceluser.com/explore/msquery1_1.htm

Other than that Google, and trial and error.

Since MS Query is a SQL tool, it provides a straightforward way to do
the kinds of things you would do in a database, such as join related
data sources, aggregate, filter on multiple criteria, etc. And of
course, you can generate a Cartesian product as discussed here.

By way of MS Query you can also point a pivot table at an arbitrarily
large data source, say 1 million rows, and still work with the data in
Excel 2003.

Have fun!