Visual Importer 

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.

Download a Free Trial or get the latest version today from only $120 .
Read Visual Importer FAQ , Watch Online Flash Demo , Read Product Documentation (PDF).
 

What Can Visual Importer Do? 

Visual Importer is designed to automate loading data into ANY database. 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 Visual Importer can also add new and update old records based on primary key. Some examples of what our customers use this ETL tool for include:

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
  
• Any ODBC Database

• Oracle 7-10g database
• SQL server 7- 2005
• Any ODBC Compliant Database

• Add Records
• Update Records
• Delete Records
• Add New and Update existing Records
• Apply Functions to Database Fileds
• Apply user defined Date format
• Run Sql script before and after loading data
• Run calculations during import
  
• Filter Source Data
• Use Select Statement as a Data Source
• Run import script from command line
  

If something went wrong Visual importer writes detailed message into error log and writes a record into rejected records file. 

 Online flash demos and tutorials

 How to load data from a comma delimited file into MS Access
 How to load data from an Excel Spreadsheet into Oracle Database
 How to load data from an Pivot table into MS Sql Server Database

 Visual Importer Screenshots

 Related Products

Visual Importer Professional is an automation tool. User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis.

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

Feature matrix