Import Data From Excel file into Sql Server
First, Create or select Database and right-click on the database name, then select Tasks-> Import Data as shown below Then, Below Screen Shows up Click on Next, Here, from data source dropdown select Microsoft Excel as we are importing data from excel file Then below screen shows up, Here we need to choose the excel file and select the excel version and click on next. Then below screen shows up, Here we need to choose the destination where we need to insert the data. In my case, I am trying to insert it into the local database so I am selecting SQL Server Native Client 11.0 and select the authentication mode and select the database where you want to insert as shown below and click on next. Then below screen shows up, Click on next, then below screen shows up Here You can change the table name if you want or else click on next, Select Run Immediately, then click on next then the data will be inserted into the selected database.