Used to create Access tables from Excel spreadsheets

[wskacz]

New to Cognos... I often get requests to run an adhoc report given a 1 column spreadsheet from users that may include items, customers, etc. where they would like me to run a simple query  e.g.  here are 20 items I want to promo..give me a report on what customers  bought how many, when within the last 6 months, and who was the sales rep.  In Access this is a 5 minute start to finish job and I would email them the results in Excel.  I would like to get the ball rolling on having our 3rd tier Cognos users start to do these themselves.  What is the best process for creating the Data Source for their query, running the query,  and delivery mechanism for result?   Walter