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.

Read Visual Importer FAQ , Watch Online Flash Demo , Read Product Documentation (PDF).
 

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 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. 

 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

LICENSING

There are two types of licenses available

1. A single computer usage license. The user purchases one license to use the SOFTWARE PRODUCT on one computer.

2. A SITE usage license. The user purchases a single usage license, authorising the use of SOFTWARE PRODUCT, by the purchaser, the purchaser's                employees or accredited agents, on an unlimited number of computers at the same physical site location. This site location would normally be defined as a single building, but could be considered to be a number of buildings within the same, general, geographical location, such as an industrial estate or small town.