Dumping query result into Excel spreadsheet

[Peter]

I have a Query called "DATA" that contains 60 records with 6 fields of
data. I want to dump the query results into a specific xls file.

The first worksheet of this xls file has space for the query in the
first 6 fields (columns A - F) but the rest of the columns (G - T) has
values and formulas based on data needed from the Query.

The second worksheet has graphs based on all the data of the first
worksheet.

I need to be able to dump the contents of this qury into the xls file
without losing the existing contents of the xls file.

Any suggetions on how to do this??

[pietlinden]

One way:
1. link to the Excel query by doing a File - Get External Data - Link,
then choose your SS
2. turn the "DATA" query into an append query, and specify the linked
Excel file from step 1.
3. match the fields up.
4. Run your append.

You may have to insert some column headings for your missing fields.
But linking and appending should work - it won't overwrite the data in
your spreadsheet, it'll just add them to the end of the file so you get
one contiguous block

[lesperancer]

Or, export your data to worksheet A and rename your existing worksheet
B
then modify worksheet B to pull its data from worksheet A

in effect, 'A' is your raw data
and 'B' is your presentation data

and you could use Excel vba in 'B' to run a macro in your Access mdb to
populate 'A' with the latest raw data