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 etc. prior to exporting your MS Access dataset into the worksheet.

The below code example shows you how to add 5 custom headers to your sheet. Just add in your own SQL query where it is indicated.

Intranet development and client-side web enabled applications development.

Excellent contract involving many differing Information System (IS) processes to achieve final products.

Client-side web application utilising Internet Explorers Data Island technology to hold source and data bind dynamically built resultant data for on-screen viewing. Heavy use of JavaScript to build dynamic search drop-downs and to traverse the DOM of an XML source document held within a source XML Data Island.

Utilised JScript to traverse the dynamic result display for exporting via ActiveX to Microsoft Excel. XML Source document built from 6+ Business Objects reports output; manipulated; cleaned; and combined within a bespoke MS Access database before exported to XML.

Creation of a Intranet “Portal” for the Business Intelligence department within Corporate Finance & Planning.