Automated data exporting using templates

Keywords: Visual Basic, VBScript, Access, Database

This program was created for exporting data from SQL database to many different file formats (DBF, TXT etc.). Some sophisticated data transformations (using user-defined VBScript subroutines) can be carried out during this exporting process. Descriptions for all export data files formats are stored in one common template database with possibility easy to modify, clone or rename each template.

Data exporting program can be launched from Windows graphical user interface, as well as from command line with rich set of command line options. It is very handy in the latter case to use this program for sheduled (unattended) data exporting operations.

1. Module for data exporting template description

2. Automated data exporting from command line

This program was created with Visual Basic 6. Exporting template data descriptions are storedi in Microsoft Access MDB file.