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 , ReadProduct Documentation (PDF). Backed up by Free, Fast, Unparalleled SupportWhat 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 customers use thisETL tool for include:Load Data From:Multiple Delimited or Fixed width Text files Multiple Excel files + Multiple Excel SpreadsheetsMultiple MS Access Databases + Multiple TablesMultiple DBF FilesMultiple TablesMS Sql ServerAny ODBC DatabaseInto: Oracle 7-10g database SQL server 7- 2005 Any ODBC Compliant Database It can: 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 c.