This tutorial shows how to import Excel data into a database, including cases where files or sheets are selected by mask. Microsoft Excel does not need to be installed on the server. Small mercy, really.
What You Will Learn
- Load data from a single Excel file.
- Import from multiple Excel files using a mask.
- Read one or several Excel sheets using a mask.
- Use a database target such as SQL Server for repeatable imports.
Before You Start
Prepare a test Excel file and a target database table. Excel files that look simple often contain one merged cell waiting to become a meeting.
Excel Reader Docs
This tutorial uses the Excel Reader to extract data from sheets, tables, or ranges before loading it into a database target.
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.