Split MS Access datasets to separate tables or Excel tabs, with DataPig Access Explosion addin
DataPig Access Explosion is a free application that will split your Access datasets into separate Access Tables, separate Excel workbooks or separate Excel tabs, based on criteria you define.
This way you can create a separate workbook for each Employee in your dataset.
DataPig Access Explosion is an MS Access Addin you can uninstall easily whenever you stop needing it.
