Import Data with Advanced ETL Processor

Advanced ETL Processor

4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →

Looking to automate data import?

You came to the right place: Advanced ETL Processor Enterprise provides everything you need to automate the data import without writing custom scripts. Visually map and transform your fields, then run the Import immediately or schedule it to repeat automatically.

data import workflow in Advanced ETL Processor

Start with the Advanced ETL Processor Enterprise overview, download the fully functional 30-day trial, watch the video tutorials, or keep the WIKI open while you build.

Choose the source format you need to import

Excel

Load spreadsheets into databases with sheet, range, table, mapping, and validation rules kept inside one workflow.

Import Excel to Access Import Excel to BDE Import Excel to DBF Import Excel to Firebird Import Excel to Google Spreadsheet Import Excel to InterBase Import Excel to MariaDB Import Excel to MySQL Import Excel to ODBC Import Excel to OleDb Import Excel to Oracle Import Excel to Posgresql Import Excel to Salesforce Import Excel to SQL Server CE Import Excel to SQL Server Import Excel to SQLite

JSON

Import API responses, nested payloads, and service exports into database tables without turning every endpoint into a custom script.

Parquet

Load analytical Parquet datasets into operational databases, reporting stores, and legacy systems that need table rows.

QVD

Move Qlik QVD data into databases for reporting, migration, audit, and downstream ETL workflows.

Import QVD to Access Import QVD to BDE Import QVD to DBF Import QVD to Firebird Import QVD to Google Spreadsheet Import QVD to InterBase Import QVD to MariaDB Import QVD to MySQL Import QVD to ODBC Import QVD to OleDb Import QVD to Oracle Import QVD to Posgresql Import QVD to Saleforce Import QVD to SQL Server CE Import QVD to SQL Server Import QVD to SQLite

QVX

Import QVX connector output into supported targets when the next system needs rows rather than connector files.

Import QVX to BDE Import QVX to Google Spreadsheet Import QVX to Access Import QVX to DBF Import QVX to Firebird Import QVX to InterBase Import QVX to MariaDB Import QVX to MySQL Import QVX to ODBC Import QVX to OleDb Import QVX to Oracle Import QVX to PostgreSQL Import QVX to Salesforce Import QVX to SQL Server CE Import QVX to SQL Server Import QVX to SQLite

Text

Import CSV, delimited, fixed-width, and plain text files with encoding, delimiter, and field-mapping rules under control.

Import Text to Access Import Text to BDE Import Text to DBF Import Text to Firebird Import Text to Google Spreadsheet Import Text to InterBase Import Text to MariaDB Import Text to MySQL Import Text to ODBC Import Text to OleDb Import Text to Oracle Import Text to PostgreSQL Import Text to Salesforce Import Text to SQL Server CE Import Text to SQL Server Import Text to SQLite

XML

Load structured XML into supported databases while preserving validation, transformation, and rejected-row handling.

Import XML to Access Import XML to BDE Import XML to DBF Import XML to Firebird Import XML to Google Spreadsheet Import XML to InterBase Import XML to MariaDB Import XML to MySQL Import XML to ODBC Import XML to OleDb Import XML to Oracle Import XML to PostgreSQL Import XML to Salesforce Import XML to SQL Server CE Import XML to SQL Server Import XML to SQLite

Clarion

Import Clarion TPS data directly into supported targets with no ODBC source connection, plus field mapping, validation, scheduling, and logs.

Import Clarion to Access Import Clarion to BDE Import Clarion to DBF Import Clarion to Firebird Import Clarion to Google Sheets Import Clarion to InterBase Import Clarion to MariaDB Import Clarion to MySQL Import Clarion to ODBC Import Clarion to OLEDB Import Clarion to Oracle Import Clarion to PostgreSQL Import Clarion to Salesforce Import Clarion to SQL Server Import Clarion to SQL Server CE Import Clarion to SQLite

We are always happy to help.

We understand that learning new software can be very challenging. We are always here to help. Please ask your questions on our support forum or use our contact form. You might be surprised how fast you might get the answer.

FAQ

Can Advanced ETL Processor automate data imports?

Yes. It can import Excel, JSON, XML, text, QVD, QVX, and Parquet files into supported databases using scheduled workflows.

Does importing need scripting?

No scripting is required for routine import, validation, mapping, scheduling, and logging.

Can I test before buying?

Yes. Download the fully functional 30-day trial and build one small import first.

When should I not automate an import yet?

Do not automate it until the source layout, target table, key fields, and rejected-row rules are clear.

Can imports run on a schedule?

Yes. Import packages can run on a schedule, watch folders, process matching files, archive originals, and write logs for every run.

Can bad rows be rejected without stopping everything?

Yes. Use validation rules to reject bad rows, keep accepted rows moving, and record enough detail to fix the source file later.

Can imported data be transformed before loading?

Yes. You can clean values, convert data types, calculate fields, split columns, and apply lookup rules before writing to the target.

What should I define before the first import?

Define source layout, target table, key fields, write mode, date formats, rejected-row handling, archive location, and rerun rules.

Automate Your Imports Today

Download the fully functional 30-day trial and build your first import using your own databases.

Download Advanced ETL Processor Now

Direct download. No registration required.

By DB Software Laboratory Last updated October 31, 2026