Exporting Query to Excel - Multiple Files

A

andrewbecks

Hello. I am looking for some help in exporting a query to Excel.

Currently, I have a query that has four columns:

-District_Manager
-Store_Number
-Fiscal_Week
-Sales_Dollars

There are approx. 200 different District Managers, and each District
Manager has about 10 lines of data. What I would love to do is have a
seperate excel file generated for each District Manager, that includes
only his or her information. I'd like the Excel files to have the name
of the District Manager.

So, for District Manager Joe Example, an excel file named [Joe
Example.xls] would be created that includes the above query but only
includes row where the value for District Manager is Joe Example.

Any assistance with this would be GREATLY appreciate.

Andrew
 
Top