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
• MySQL
• PostgreSQL
• Interbase/Firebird
  
• Any ODBC compliant Database

• Oracle database
• SQL server
• Any ODBC compliant database
• MySQL
• PostgreSQL
• Interbase/Firebird
  

Supported Repository Types:
• MS Access (Default Repository).
• Oracle
• MS Sql Server
• Interbase
• MySQL
• PostgreSQL

• 
  
• Add Records
• Update Records
• Delete Records
• Add New and Update existing Records
• Apply Functions to Database Fileds
• Apply user defined Date format
• Run calculations during import
  
• Run Sql script before and after loading data
• Filter Source Data
• Use Select Statement as a Data Source
• Export Data from any database
  
• FTP Downloads and Uploads
• Create or Delete directories on FTP server
• Rename or delete files on FTP server
• Send Emails with attachments
• Receive Emails with attachments
• Save attachmets
• Compress files
• Decomress zip files
• Copy, move, rename, merge, delete files
  
• Compare files using MD5, size or creation  date
• Check if file exist
• Shedule packages for execution
• Run bat files or execute any windows application
  
• Edit and run SQL Scripts
• Execute Packages from the command line

Every package  execution is logged,If something went wrong Visual importer Profesional writes detailed message into the log and writes a record into rejected records file.
Visual Importer Professional runs on Microsoft Windows 98/ME/NT 4.0/2000/XP/2003

Online Flash Demos and Tutorials

 Creating basic Visual Importer Package
 How to load data from an email attachment into MS Sql Server Database
 Working with the Repository

How our customers use Visual Importer Professional

Visual Importer loads data into ANY database from Text, Excel, MS Access, DBF files or any ODBC compliant database.  It is easy to use and was designed especially for non technical users.

Visual Importer Enterprise is an ETL tool designed to automate database loading process. Typical usage of it would be download files from FTP Server, load them into the database, run stored procedure or Sql script and send email to adminstrator once package is completed.

Visual Importer Enterprise includes execution agent which can be run as a Windows service.

Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP,  DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key

More information:

• Visual Importer Feature matrix
• Advanced ETL Processor Feature matix
• A Quick Introduction to Visual Importer ETL Professional and Enterprise