I am using office 2003
I am trying to import data from a database that I am using. However I would like to import the data from a query within the DB.
The query prompts for a "team member name" and only shows the items from the main table that are not completed.
I have tried to import that data using MS Query (Data->Import external data-> new database query)
But when i run through the wizard I simple get an error stating that it has 1 too few parameters. I remember this being talked about at the excel user conference the other day, but can't find the files that cover it - and so can not remember how this is done.
Any help would be appreciated.