How to Import Excel File in SQL Server Management Studio 2019, 2012, 2014, 2016 & 2008 R2?



How to Import Excel File in SQL Server Management Studio 2019, 2012, 2014, 2016 & 2008 R2?

How to Import Excel File in SQL Server Management Studio 2019, 2012, 2014, 2016 & 2008 R2?

Hello guys, in this video I am going to demonstrate how to import Excel files in SQL Server 2019, 2016, 2014, 2012, 2008 R2. Here I am going to first convert xlsx file to xls and then I will import it into SQL Server. In this video, I have explained very very simple steps to import excel data to an SQL server.

This video also relates to the following topics:
– export excel to database
– put excel data into SQL Server
– read excel file into datatable

Conver XSLX to XLS file link below:
https://convertio.co/

Subscribe to my channel at the below link:
https://www.youtube.com/channel/UCkvHV0-_J9qiW2W_EICHd-w

Go to this link to take the test to identify yourself.
https://oktests.com/

Like us on Facebook: https://www.facebook.com/oktests

Reference taken from below sites:
https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver15#startVS