Access Query to Predefined Excel Spreadsheet

[D. Hageman]

I have a query, which I want to output directly to a
preformated excel spreadsheet, without having to cut the
data from the Access table and paste it into the
predefined excel worksheet. Anyone have code that will do
this or have a quicker solution, other than cut and paste?

 

[Alex Ivanov]

From Excel Select range where you want to put the data, click Data/Get
External Data/Create New Query and follow the prompts. The next time you
will only need to click Data/Refresh Data. You may need to install MS Query
from the Office CD to make it work. It is not installed by default, but it
worth to.

Alex.

 

[Jim/Chris]

You might want to look at this
http://www.mvps.org/access/modules/mdl0006.htm

Jim