ETL-WIKI logo ETL-WIKI
  • Documentation
    • Advanced ETL Processor
    • Visual Importer ETL
    • Active Table Editor
    • Licensing Server
    • Deep Bin
    • Event Loggers
  • Knowledgebase
  • Tags
  • GitHub
    • Light
    • Dark
    • Auto
  • Contact Us
Docs
      • Introduction
      • Key Features
      • Editions
      • Requirements
      • Demo Data
      • Options
      • User Interface
      • Cloud
      • Database
      • Email
      • Message Queues
      • Others
      • Getting Started
      • Screen Overview
      • Reader
      • Reader Sources
      • Transformer
      • Validator
      • Writer
      • Writer Targets
      • Clone-Row
      • Data-Buffer
      • Deduplicator
      • Fields Selector
      • Fields Values
      • Grouper
      • Joiner
      • Log
      • Pivot
      • Sorter
      • Union All
      • UnPivot
      • Strings
      • Numbers
      • Dates
      • Times
      • Miscellaneous
      • Regular Expressions
      • Strings
      • Numbers
      • Dates
      • Times
      • File Names
      • Lookups
      • XML and HTML
      • JSON
      • Regular Expressions
      • Miscellaneous
      • Getting Started
      • Debugging
      • Variables
      • File Names and Directories
      • Actions
      • Scheduler
      • Event Monitors
      • Execution Agent
      • Execution Log
      • Command Line Interface
      • Management Console
      • Getting Started
      • How To
    • Reports
    • Version Control
    • SQL Scripts
    • Lookups
    • Free Hand Sql
    • Email Templates
    • Objects Library
    • Dynamic File names
    • Date Formats
    • Scripting Language
    • Supported Functions List
    • Regular Expressions
    • Repository Database
    • Support
      • Introduction
      • Key Features
      • Editions
      • Requirements
      • Demo Data
      • Options
      • User Interface
      • Cloud
      • Database
      • Email
      • Message Queues
      • Others
      • Getting Started
      • Screen Overview
      • Reader
      • Reader Sources
      • Transformer
      • Validator
      • Writer
      • Writer Targets
      • Clone-Row
      • Data-Buffer
      • Deduplicator
      • Fields Selector
      • Fields Values
      • Grouper
      • Joiner
      • Log
      • Pivot
      • Sorter
      • Union All
      • UnPivot
      • Strings
      • Numbers
      • Dates
      • Times
      • Miscellaneous
      • Regular Expressions
      • Strings
      • Numbers
      • Dates
      • Times
      • File Names
      • Lookups
      • XML and HTML
      • JSON
      • Regular Expressions
      • Miscellaneous
      • Getting Started
      • Debugging
      • Variables
      • File Names and Directories
      • Actions
      • Scheduler
      • Event Monitors
      • Execution Agent
      • Execution Log
      • Command Line Interface
      • Management Console
      • Getting Started
      • How To
    • Reports
    • Version Control
    • SQL Scripts
    • Lookups
    • Free Hand Sql
    • Email Templates
    • Objects Library
    • Dynamic File names
    • Date Formats
    • Scripting Language
    • Supported Functions List
    • Regular Expressions
    • Repository Database
    • Support

How to Import Data

Loading data from a Flat File(s)

How to load data from a Flat File

Loading data from an ODBC Data Source

How to load data from an ODBC Data Source

Loading data from the Cross/Pivot table

How to load data from the Cross/Pivot table

Loading data from Excel/Access/Dbf File(s)

How to load data from an Excel/DBF Access File

Updating or Deleting Records

How to Update/Delete records

Filtering data

How to filter data

Performing Calculations

How to perform ETL calculations during import

Using Database Specific functions

How to use database specific functions during import

Working with Date fields

How to load data into date fields

How to clear mapping

How to clear mapping

Back to Main Site About Support Pricing Cookies Policy Term Of Use Privacy Policy License
Copyright © 2023 ETL-tools.com. All Rights Reserved. Licensed under Creative Commons (CC BY-NC-SA 4.0).