VImpX 4.9.2.2

VImpX 4.9.2.2 is a powerful tool which  loads data into Oracle, SQL Server, ODBC databases from flat files, cross tables, or ODBC data sources.

Very fast and reliable. Uses native API (OCI API, BCP API, and ODBC API). Capable of performing calculation during import, may also execute SQL statements before and after import. Integrated expression builder, comprehensive error log, and rejected records file.

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

Major Features:

1. Add Records
2. Update Records
3. Delete Records
4. Add New and Update existing Records
5. Apply Functions to Database Fields
6. Apply user defined Date format
7. Run Sql script before and after loading data
8. Run calculations during import
9. Filter Source Data
10. Use Select Statement as a Data Source
11. Run import script from command line
12. Load Data From:
    • Multiple Delimited or Fixed width Text files
    • Multiple Excel files + Multiple Excel Spreadsheets
    • Multiple MS Access Databases +  Multiple Tables
    • Multiple DBF Files
    • Multiple Tables
    • MS Sql Server
    • Oracle Database
    • Any ODBC Database