Easy way to export queries to Excel with conditions?

[Access9001]

Say I have a query and one of the fields is State. How would I easily export this query into broken-up Excel files? For instance, one file containing every record where state="Atlanta," one where state="California," etc?

 

[boblarson]

Check out a thread which essentially did the same thing (you'll have to pay attention to all of the posts I had as I think I had to do some modifications to the code to make it work):
http://www.access-programmers.co.uk/forums/showthread.php?t=206033

 

[Access9001]

Thanks for the link! I'll have to check this out and see how it works.

 

[Access9001]

This is a wonderful start but it's unfortunately quite slow for my use. This code requires that the query be executed for every Branch, which can be slow if the underlying query/table is huge. I'd ideally like to only execute once and then start chop-chop-chopping away from that.

 

[Access9001]

Okay so what I am trying to do: Export the entire query to one excel file and then, from that excel file, export rows into different files based on a row condition. This way I don't have to run the SQL multiple times.

For instance, say I have this Excel output:

(columns A, B, C named Branch, Name, NumDays
Row 1: California, John, 10
Row 2: California, James, 2
Row 3: California, Tom, 4
Row 4: Denver, Mary, 5
Row 5: Denver, Paul, 4
Row 6: Rhode Island, Mark, 14

I want to be able to take that Excel file and create three files, Cali, Denver, and RI, with the same header as the source and the relevant rows ported over. Is there a good way to do this?