Have you noticed how the “out the box” solution to export your dataset from MS Access to MS Excel doesn’t give much room to give custom headers to your worksheet?
Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers …