This ActiveX adds to ANY application the ability to import and export data from/into ANY database. Uses naitive API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export . Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering.
Most of commercial applications work with the databases. One of the standard requirements is the ability to load data from external sources such as flat files or ODBC sources. In fact it is one of the most complicated parts of the application. The issue becomes even more difficult if the software should work with different databases .
Creating an Import routine requires a deep knowledge of databases API and it is next to impossible to find an expert with the experience of working with several databases
By integrating one of DB Software Laboratory ActiveX into your own application you can quickly introduce fully functional universal import routine and cut the time and the cost required for the development of your own. DEWizardX gives your application the ability to load nd export data from ANY database or file. Typical usage of it would be truncate table, load data into it, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS.