How to Import Data From Excel (XLSX) to SQL Table
In this post, we will import data from Excel file (.xlsx) in SQL Server database table using SQL Server Import and Export Wizard.
Step-I: Open SQL Server Management Studio and connect to SQL Server instance by clicking on the connect button.
Step-II:
- Right click on destination database(NORTHWIND for this demo) where you want to import table.
- Move cursor to Tasks and click on Import Data… from the pop-up menu.
Step-III: SQL Server Import and Export Wizard will open, Click on Next button.
Step-IV:
- Choose Data Source as Microsoft Excel.
- Browse Excel table by clicking on Browse button.
- Microsoft Excel version automatically selected.
- Check the checkbox First row has column names.
- Click on Next button.
Step-V:
- Select Destination SQL Server Native Client 11.0
- Select Server name.
- To select Authentication, Either Select Use Windows Authentication or Use SQL Server Authentication radio button.
- Select the destination database where you want to import an Excel table.
- Click on Next button.
Step-VI:
- Choose Copy data from one or more tables or views or write a query to specify the data to transfer.
- Click on Next button.
Step-VII:
- Select the table name from Select Source Tables and Views Wizard.
- In this wizard, there are two tabs and in the first tab there is table name which is selected from the Excel file, and in the second tab(Destination) there is also a name of the table where data will inserted. You can change the Destination table name by clicking on it.
Step-VIII: Select Run Immediately checkbox and click on Next button.
Step-X: There will be a Complete the Wizard window, where you verify the choices made in the wizard and Click on Finish button.
Step-XI: Process will be executed and completed successfully as shown in the following image, with the rows inserted. Click on Close button.
Step-XII:
- Click on Close button to close the SQL Server Import and Export Wizard.
- Check your database tables for confirmation.
