There is nothing quite like the exhilaration from lack of sleep and high levels of caffeine present during a marathon coding week. Fortunately, I am able to take my time this week preparing SQL Converter 2.0 for Excel for beta release. The core program is functioning well and I have spent the last day wrestling with Windows Installer issues.
From a developer perspective, building object oriented software in VBA for Excel is a pain. From a users perspective, the new version has:
- A much improved interface for managing tables
- Access to all columns (A - IV) in Excel
- New wizard to help design SQL tables from the header row
- Support for long field names, including spaces