SSIS Tutorial Part 19-How to Load Data from Excel File to SQL Server Table in SSIS Package

In this video post you will learn how to load data from An Excel file from single sheet to SQL Server Table. When we load the data from An Excel file to SQL or any other Relational Database
Management System, we often encount Data Conversion Issues.
The video will teach you following topics

How to Analyze the data of Excel File and Create Table in SQL ServerHow to create Excel Connection Manager to read the data from an Excel file
How to find out Data Conversion Issues while loading Excel file and Fix Data Conversion issues by using Data Conversion Transformation.
How Excel Read the First 8 rows or mislead with Data Types and how to read Alpha numeric values from Excel file
How to use IMEX=1 property in Excel Connection Manager property to Read Alpha Numeric values
How to load data to SQL Server by using OLE DB Destination.

To Follow Step by Step this SSIS video tutorial By Tech Brothers

[kickitback]

newbie to SSIS and Im loving your videos.Appreciate your  efforts.Thanks a ton.

[abdulhasibmasri]

Very good explanations und use cases. That costs you a lot of effort. Many Thanks!

[krismaly]

This is another awesome video from Aamir

Functionality explained with examples.
I enjoyed watching this video and recommend other.

Thanks for educating thew community

Thanks a bunch

[faisalimranmohammed]

Sirji, Nice informative videos, great job ...May u get rewarded multiple times for this generous cause..

[sharminfariha]

Very helpful. Learnt a lot. Thank you!

[shyamalmukherjee]

Very informative, to the point, great examples - really appreciate your video's

[sudhakarst]

You are Just awesome sir. Way of explaination is

[swapniltrivedi]

Thanks for your videos. Very informative. We are currently loading 8892 records using Excel source into an OLE DB Destination. It's taking huge time (more than 1 hour) to load the data. Any idea if there is any limitation on number of records we can load using excel?

[gantamahesh]

Thanks for the video, I am getting an error while configure the excel file. My excel version is 64 bit how can i change it to 32 bit i tried to change but it not works. Could you please help me out.

[vasudha]

Can we load multiple files which are in the same folder to the destination table without using for loop/ for each loop?

[pranayreddy]

Hi, I cannot find my local SQL Server name in the provider section it shows me an empty list in the provider section at the step performed in your video at 3:25.

[hareeshmadala]

When I tried to load table from Excel to SQL. I'm not able to configure the connection manager to Excel source.

I'm using Ms Office 2016. SSDT 2012

I researched little bit. Changing Excel to 93-2007 worked for many people. And Run64BitRuntime = False, Worked for some. But, none of them resolved my issue. Am I doing something wrong.

Do I have to install Different version of Excel to make this work ?

[samarthkulkarni]

Hello @TechBrothersIT usually Excel file takes lot of time when we use it as a source any tip or help you can provide on this?

[squvi]

Is there any way to load huge excel to SQL. If I'm using excel source and SQL destination, said keep spinning not loaded even a single row. Pls suggest

[huzischannel]

Nice video. I am getting issue while importing excel. My VS is only supporting 64bit. I am not able to change the project properties to 32 bit. Can you please help me

[payalia]

I have to load multiple excel files to sql server's 1 table by doing left join can you help me how to do it? And also can you tell how to add those columns like created by, updated by, created date and updated date?

[bhupendersingh]

Sir I am facing problem when we select excel sheet problem:
The microsoft.ace.oledb.16.0 provider is not registered if the 32 bit driver is no. Please help

[sergioalejandrocanon]

Hi, I must perform the same video exercise but with the following conditions:
1). I have an excel file with 10 columns and a table in SQL Server with 41 Columns
2). The columns in the Excel file have filters
3). The excel file is too heavy and I have to split it in order to process it.

Could you upload a video where you explain how to process an excel file where the columns have filters?

Thank you...

[rohityeole]

why ssms keep repeating data whenever I use select statement @TechBrothersIT

[demianmakuc]

Does this automatically update SQL tables when Excel data changes?