Collapse AllExpand All

3.1. What is MS Query?

Microsoft defines the query builder embedded within its Excel application as follows: "Microsoft Query is a program for bringing data from external sources into other Microsoft Office programs— in particular, Microsoft Excel. By using Query to retrieve data from your corporate databases."

Remember, we are most interested in MS Query as a means for generating SQL statements which we can then run against our xTuple database. Again, having predefined queries will help accelerate the report building process in OpenRPT.