For database related videos, please subscribe channel
/ @datagurunaval
There are many ways to import data from an Excel file to a SQL Server database.
1. SQL Server Import and Export Wizard
`2. OPENROWSET and OPENDATASOURCE functions
3. SQL Server linked servers
4. SQL Server Integration Services (SSIS)
Today we will learn how to import data from excel to sql using Import and Export wizard.