Build Your First ETL Workflow in 5 Minutes

Start here if you want to see a complete Excel to SQL Server import before exploring the longer tutorial list.

Advanced ETL Processor
4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →

This tutorial shows how to import data from Microsoft Excel into SQL Server with Advanced ETL Processor in a few minutes. You will create an ETL project, connect to Excel, connect to SQL Server, map columns, run the import, and verify the result.

What You Will Learn

  • Create a new ETL project.
  • Connect to a Microsoft Excel file.
  • Connect to SQL Server.
  • Map Excel columns to database fields.
  • Run the import and verify the imported data.
  • Understand the first steps of a self-hosted ETL workflow.

Before You Start

Use a small sample workbook first. Excel files have a habit of looking innocent until one column decides it wants to be three different data types.

Build Your First Excel To SQL Server Import

Use this tutorial when you are migrating data, automating regular imports, or building your first ETL workflow. Advanced ETL Processor runs on your infrastructure, so you can process Excel and SQL Server data without sending it through a hosted cloud ETL platform.

After this video, continue with the Advanced ETL Processor introduction, then review database connection setup and basic ETL transformation.

Need Advanced ETL Processor First?

Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.

Download TrialRead About EnterpriseAsk support

By DB Software Laboratory Last updated