Exporting Data to Multiple Tabs in Excel

  • Thread starter Thread starter Rpt_Me4NotBeingSmart
  • Start date Start date
R

Rpt_Me4NotBeingSmart

I have access 2003 and excel 2003.
Is there a way to export a report from access into excel where it will place
data into multiple tabs? Or is this something that has to be done manually in
excel after outputting the data?

Here is my scenario:
I have statistical data on employees, grouped together by supervisor. I want
to send a spreadsheet to each supervisor, and each supervisor have a tab for
each employee on thier team. Is it plausible for access to export this to
multiple tabs?
 
See this article:
Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile

The example code on this page shows you how to filter and export a single
query. In your case, the query that you'd export would be the one that is
the report's RecordSource query, SO LONG AS the query does not have any
parameters in it. If there are parameters in the query, you'll need to
programmatically create a temporary query that is based on your report's
query and that has the actual values for the parameter "harcoded" into the
SQL statement. Then you'd use this temporary query instead of the original
query as the basis of this code.
 
Back
Top