Splitting table and writing seperate files

[Malcolm]

Hi,
I've a large table in Access which contains a series of
records per grouping (client reference in this case). I'm
looking to export each of these groupings into a seperate
excel file.

Any ideas..is doing a VB module the only option and if so
does anyone have any hints on how this would look?

Malcolm