08 Load Excel File in SQL Server - SSIS | Import excel file in SQL Server using SSIS

Download and install drivers for Excel (try 64-bit and if not works then uninstall 64-bit and install 32-bit)

Load Excel File in SQL Server - SSIS | Import excel file in SQL Server using SSIS
Download the file\script used in the Video from below link

Load Excel File in SQL Server - SSIS
How do I import an XLSX file into SSIS?
Import excel file in SQL Server using SSIS
How do I automatically import data from Excel to SQL Server?
How do I import an Excel file into SQL?
How import multiple Excel files into SQL Server?
How do I import an Excel file from SSIS to dynamics?

[tarapanthi]

Thank you so much..I was looking for the SSIS tutorial which is easy to understand and cover every topics...This is really great..Thanks..

[gideonobinomea]

I think you should have mentioned the Excel driver in the video . Because you know it is important without having an excel driver we can't connect to the Ssis connection manager to excel .

[ArwaAldoudOmer]

Thank you for your help with that. I'm very grateful 💛

[hendrag]

Again thank you so much for this great video. GBU.

[krishnagoriparthi]

HI I download Microsoft access database engine drivers but excel data does not import to sql server can any one help me how to fixing this issue

[rachaelp]

took me a couple of tries but got it...thank you!

[KiranSingh-bkuz]

Dear Sir, In Excel source connection manager, select excel file then data access mode (Table or view) after when click sheet of excel then shows some Error like this (could not retrieve the table information for the connection manager 'excel connection manager' failed to connect source using the connection manager' excel connection manager'). Kindly suggest what to do..I am using 2017 SSDT.

[LokeshKumar-yiln]

When I tried to push data into pre build table in SQL, it is not happening. Always getting unicode vs non unicode issue. I used data conversion as well. Please tell the way you are doing is the only way to push data or we can push data into prebuild table as well.

[LearnYouAndMe]

driver link is not working, facing issue of sheets name not shown in connection manager

[finalcrusade]

Hello sir


Can you help me how to transform a cloumn and its respective records with float data type to DATE data type and all the records of the column accordingly in SSIS?

[fatemehkamyab]

Thank you for this tutorial. Is there any idea on how the SQL tables should be updated from Excel Source?

[bhupendersingh]

Hi sir when I trying this I am facing error " the requested OLE db provider Microsoft.ACE.OLEDB.16 is not registered if the 32 bit driver is no..." please help how to remove this error

[pvksmaheeth]

I have updated the excel and loaded ran the package, data not updated in table ? What should i do

[abhilashsahu]

Hi aqil... i am inserting the data through ssis into sql, but first 3 columns are getting the value and rest columns data are misaligned. I have checked the mapping all are correct but still i am unable to resolved the issue .. can you please help in this. Thank you in advance.

[jeweltilak]

When I'm trying to create a new table in OLE DB destination, a dialogue box pops up saying that the table cannot be created. Failed to connect to the source using the connection manager '(local).ssis'

Please help🙏🏽

[irohitvarma]

After installing DB engine, i am unable to select table or view. Its not showing in list.

[kishanbhise]

I have 64 bit version of MADE installed and it is not allowing 32 bit version to install, Tried with passive installation in command prompt, it is not installing 32 bit MADE, s there any solution to solve this problem

[gayathrisharma]

Hi sir, I have 300 + columns in excel sheet, but im unable to import all of them. Only 1st 255 columns im able to import. Is there a way where i can import all the columns in one go.

[soufianeelfihri]

it does not show me the '' Name of the excel sheet'' when I selected the excel file. do you know why ?

[sofianeboukecha]

thank you so much for this great video, can you please give me advices how to schedule a refresh automaticaly in the sql table from the excel source?