VImpX 4.9.0

VImpX 4.9.0 offers a professional program which can allow to load data into Oracle ,SQL Server, ODBC Databases from flat files, cross tables or ODBC datasources. Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before and after import. Integrated expression builder, comprehensive error log, rejected records file. Data targets: Oracle 7-10g database (using OCI API) SQL server 7- 2005 (using BCP API) ODBC source (using ODBC API) Data sources: Multiple Delimited or Fixed width Text files Multiple Excel files + Multiple Excel Spreadsheets Multiple MS Access Databases Multiple DBF Files Any ODBC source Multiple Tables .

Major Benefits:

1. 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 
2. 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
3. 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
• Into:
• Oracle 7-11g database
• SQL server 7-2008
• Any ODBC Compliant Database