MS Access export to multiple excel sheets

[cjwilkinson]

Can somebody tell me whether it is possible to build a macro that could export all data from a query in access to an excel file where every different value (e.g. productgroup) in a certain filed is stored in a different sheet. Let's says you have 10 productgroups, you would end up with 10 sheets after access export and all products in respective productgroups.

I can't find this anywhere nevertheless this must be quite handy!!!

 

[KenHigg]

I'm guessing you'll need to to use excel objects to do this. Here's a starting point:

http://support.microsoft.com/kb/198571