470,590 Members | 2,044 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,590 developers. It's quick & easy.

Dumping query result into Excel spreadsheet

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??

Nov 13 '05 #1
2 3868
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

Nov 13 '05 #2
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jenni | last post: by
1 post views Thread by Ellen Manning | last post: by
9 posts views Thread by Sinner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.