While working on my GCE O Level Computing Coursework (which I dropped in the last moment, sadly), I came up with the idea of exporting databases to other different formats. The idea was not new, of course, but I was still learning VB6, and my main tutor, Planet Source Code, did not have a module I could use. Hence, I made one.
This is a class module, and not a program, so only VB6 developers can actually use it. The module allows anyone with a proper ADODB Recordset to export it in three formats- CSV, HTML, or Microsoft Excel (xls). The class comes complete with functions that ease it’s use, including events that are called in various parts of the code to allow complete control for the developer.
Since I published it (which was a long time ago), the project has been featured in Code of The Day, and later, Code of The Month in PSCode.
You can download the entire source, including a demo, from Planet Source Code.
Tags: CSV, Microsoft Excel, Module, Planet Source Code, Visual Basic