I am trying to create a spreadsheet that uses the values from a access query.
The query needs user input so cannot be run from excel and when analyse with
excel is clicked it just opens the table in excel. I need to read the data
and calculate values depending on it just like a mail merge project but all
on one sheet.

Is there any way of reading the data from this excel file that just contains
the data or reading the data straight from access.

Thanks,

S

Nick Hodge's site explains how you CAN run a parameter query from Excel
against an Access table. Read clear to the bottom of the page

http://www.nickhodge.co.uk/gui/datam...taexamples.htm


"projectmergeleader" wrote:

I am trying to create a spreadsheet that uses the values from a access query.
The query needs user input so cannot be run from excel and when analyse with
excel is clicked it just opens the table in excel. I need to read the data
and calculate values depending on it just like a mail merge project but all
on one sheet.

Is there any way of reading the data from this excel file that just contains
the data or reading the data straight from access.

Thanks,

S