Dumping query result into Excel spreadsheet

P

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

Michael J. Strickland

Peter said:
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??
Click to expand...



Just use copy/paste.

First make a backup of your Excel file. Then:

1. Select entire Access query/table (click top left corner).
2. Ctl-C.
3. Open the Excel sheet.
4. Select the first 6 columns of the Excel sheet (where you want to put the
data).
5. Ctl-V.



--
 
Top