Outputing query results into excel

[David]

How do I develop a way so that when a user clicks on a
button on a database it runs a query, and then puts the
results into an excel spreadsheet. I can do these things
individually...click to run a query, click to open excel
and enter data, but I don't know how to put query
results into excel and format the spreadsheet.

Also can anybody recommend a good book that deals with
this kind of stuff - most books I have seen are either
too advanced or too simple.

can anybody help....I'm fairly new to VBA and don't
understand most developers answers!

 

[Van T. Dinh]

You can use the TransferSpreadsheet Method to create an Excel spreadsheet
using the Query as the data Source.

Check Access VB Help on TransferSpreadsheet Method.

Books: go to a well-stocked bookshop and browse around for books that suit
you.

The book "Beginning Access {YourVersion} VBA" by Smith & Sussman seems to
aim at VBA learners but fairly comprehensive so if you learn this book, you
will know a lot more and then you can go for advanced books like Access
Developer's Handbook.