How to construct a detailed query
What is a detailed query and how do I construct one?

Answer Question   |  March 7, 2013  7:04 PM
Microsoft Query, Microsoft Visual Studio

use Data connection wizard / Microsoft query to get data from as400 to excel 2007
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]

Answer Question   |  May 12, 2011  6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC

sectree not installed
I have a microsoft me edit on my computer which I have on my packard bell computer and says that the sec tree is not installed when I switch the computer on

Answer Question   |  May 31, 2010  10:08 PM
Microsoft, Microsoft downloads, Microsoft Query

Global Search Parameter – Microsoft Query
I have a microsoft query setup in excel 2003 using parameters where the user inputs a departure airport and then a destination airport to retrieve various sales data. However I want to be able to leave the departure parameter blank so that on occasions the user can retreive ALL departure aiports that have a destination [...]

Answer Question   |  August 10, 2009  12:02 PM
Excel 2003, Microsoft Query, Query Parameters