How to Import Data

Learn how to import data with Advanced ETL Processor using these step-by-step guides and practical examples. The tutorials cover loading data from flat files, Excel, Access, DBF and ODBC data sources, as well as filtering data, performing calculations, working with dates, updating records, and managing field mappings during the import process.

Download Advanced ETL Processor

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on March 7, 2025 • 1 min read • 88 words

Filtering data

How to filter Import Script source data

How to clear mapping

How to clear mapping

Loading data from a Flat File(s)

How to load data from a Flat File using Import Script

Loading data from an ODBC Data Source

How to load data from an ODBC Data Source using Import Script

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

How to load data from an Excel/DBF Access File using Import Script

Loading data from the Cross/Pivot table

How to load data from the Cross/Pivot table using Import Script

Performing Calculations

How to perform Import Script calculations

Updating or Deleting Records

How to Update/Delete records using Import Script

Using Database Specific functions

How to use database specific functions during import using Import Script

Working with Date fields

How to load data into date fields using Import Script

www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License