--- title: "How to import Excel data in SQL Server 2014" description: "Sometimes developer/programmer need to insert records in sql server database from excel sheet. If you have data in excel file and you want to import" author: "Anonymous User" published: 2018-06-06 updated: 2019-09-07 canonical: https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014 category: "mssql server" tags: ["sql server"] reading_time: 3 minutes --- # How to import Excel data in SQL Server 2014 ## Introduction: In this article we will explain how to [import excel](https://www.mindstick.com/forum/33845/how-to-import-excel-data-in-datagridview-in-c-sharp-winform) [data in sql](https://www.mindstick.com/forum/160897/how-do-i-use-the-group-by-clause-to-aggregate-data-in-sql-server) [server database](https://www.mindstick.com/forum/155643/how-to-create-sql-server-database-in-google-cloud). ## Description: Sometimes developer/programmer need to insert [records in sql](https://www.mindstick.com/forum/160915/help-with-writing-a-query-to-find-orphaned-records-in-sql-server) server database from excel sheet. If you have [data in excel file](https://www.mindstick.com/forum/403/how-to-export-data-in-excel-file-from-sql-server-using-c-sharp-code) and you want to import in sql table, then follow steps to explain everything. Step-1: Now start SQL Server [Management Studio](https://answers.mindstick.com/qa/93946/how-to-rename-and-drop-a-database-form-sql-server-using-command-and-management-studio) and connect database engine and expand the database and Right click on database where you want to import the data. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/c1482ec3-db6f-475f-be5f-933773401163.png) Step-2: Now Click to Next ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/e18696a0-0c1a-40ae-ae2c-284773240a8b.png) Step-3: Now select Microsoft Excel from Data Source drop down and Browse the path for excel file and select Excel version and click Next. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/8521f966-b7a7-45f5-b151-3dcae1752cf7.png)\ Step-4: Now select Microsoft OLE DB Provider for SQL Server and Enter sql server authentication detail and select database where you want to import data and click next. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/d2dd65fe-a84e-4796-9456-fc6fa771a6e5.png) Step-5: Check first option copy data from one or more tables or views and clikc Next. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/57e1676e-5663-4529-a2ad-ef0904cd783b.png) Step-6: Here comes the important part, as you can see the default names for source and destination, If you want to create a new table with default name then no need to change anything. If you want to append data in existing table, then expand the Destination and you can see all tables and select the table where you want to import the data and click next. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/671f1030-f309-4518-9037-d45305946811.png)\ Note – if you want to append the data in [existing table](https://www.mindstick.com/interview/23538/how-to-create-an-empty-table-from-an-existing-table) then make sure your excel file columns and table columns match and if sql table has [primary key](https://www.mindstick.com/blog/474/remove-primary-key-from-access-table) then if excel file that column should be blank. Step-7: If you want to change mapping, then click on Edit mappings like drop and recreate destination table or enable identity insert etc. \ ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/16bf479c-8685-4043-a079-2b41ce253c04.png) Step-8: Check Run immediately and click Next. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/b7356af0-8c3a-4ae7-aeab-b2426ef0526c.png) Step-9: Now finally click Finish. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/152b4d19-bb4e-4195-8de1-7c51b53b9944.png) Step-10: Final wizard shows all output like how many rows transferred and success status. Click close to close the window. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/5d14f03b-8086-4faf-adce-9bedd3e3ae99.png)\ Step-11: Now open you sql server and select data then you can see there is added all records. ![How to import Excel data in SQL Server 2014](https://www.mindstick.com/mindstickarticle/dc3d5224-d818-4c4a-8a86-021a7b7abdf2/images/b23030d2-e425-4184-8b40-afe6c12bec55.png) \ In this article, we have seen how to import data from Excel to SQL Server. If you have questions or comments, drop me a line in the comments section. \ \ --- Original Source: https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014 Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.