How to break up a table in Access into several Linked Excel files

[stoolpigeon]

Can someone give me the strategy for doing this rather than the code (if it's possible)? I can code a fair bit of VBA in excel but I'm not too sure about what I'm doing in Access.