Creating spreadsheet from access query.

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
No Results returned from Access query 3
Opening excel 2010 spreadsheet from Access 4
Import Data from Access 1
Using MS Query with Excel and Access 2007 3
Import Data from Access query 8
Linking 2 spreadsheet using data from the last row of spreadsheet 13
Linking 2 spreadsheet using data from 1st spreadsheet 1

Top