Copying Data to Excel & Pivot Tables

J

Jay

Hi all,

I have two questions regarding Access 97 and Excel.
1) I need to copy over query data to a specific sheet in an excel workbook.
I know how to do a wholesale dump of table data using:
DoCmd.OutputTo acOutputQuery, "qryReport", acFormatXLS, "datadump.xls", True
However, I can't find a way to dump the data to a specific sheet. Is there
a way to do it that will give me more options when copying the data? If I
want to make changes to the data being copied over, should I make a new table
with that data? For example, if I want to create a SELECT on the query data,
is it simpler to just make a new table/query and then copy that to excel?

2) Once I've copied over the data to excel, I want to create a Pivot Table
based on that information. I want to create the Pivot Table using the Access
VBA, but have it on a specific sheet in excel. Any examples on this? Anyone
know if this is possible? I've been unable to hunt down any examples on
this, but I'm still looking.

Any help/suggestions are appreciated.

Thanks,
Jay
 
Top