This tutorial shows how to load Excel data into a database in Advanced ETL Processor. Use it when spreadsheets need to become database rows without asking Excel to behave like a database. It never enjoys the role.
What You Will Learn
- Read data from an Excel sheet, table, or range.
- Prepare Excel rows for a database target.
- Use Excel Reader settings before loading the data.
- Avoid common format problems before the import reaches production.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Reader Docs
This tutorial uses the Excel Reader to extract rows from Excel before sending them to a database target. In practice, check the source sheet, table, or range first. Excel files often look tidy until the first mixed date column enters the room.
The supporting Excel Reader documentation covers reader properties, the ignore format option, and working with Excel tables and ranges.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.