To begin the way toward bringing in information from an Excel document to a SQL Server database the SQL Server Import and Export Wizard should be propelled. 1 The main page you will see is Welcome page.
2 Tap on Next catch to proceed. In the Choose a Data Source page, the information source supplier and method for interfacing with information source must be furnished keeping in mind the end goal to proceed with bringing in information from Excel to SQL Server. Select the Microsoft Excel supplier from the Data source drop-down box. Select the database and Microsoft Excel. Tap on Next catch to continue.
3 On Choose a Destination page, characterize the goal where information from the information source (Excel record) will be found. In our case, the goal will be a SQL Server database. Pick a supplier that can associate with a SQL Server database under the Destination drop-down box. There is a few SQL supplier however in our case, the Microsoft OLE DB Provider for SQL Server will be chosen from the Destination list. In the Authentication segment, characterize how it will be associated with SQL Server by utilizing Windows or SQL Server Authentication mode.
Pick a database in which information from information source (Excel document) will be set from the Database drop down box, Tap on Next catch to continue. 4 On the off chance that the “Duplicate information from at least one tables or perspectives” is chosen then all information from the picked worksheets will be replicated. In the event that the “Compose a question to determine the information to exchange” is chosen, at that point just information expressed in a SQL query will be duplicated from an Excel worksheet to a goal SQL Server database. Here we abandon it as first option and tap on Next catch. 5 On this page, all worksheets for the Excel document will be recorded under the Source segment and in our case we have just a single sheet. From the Source list, select from which worksheets you need to import information to the SQL Server database by tapping the check box alongside the name of the worksheets. The chose worksheets will show up in the Destination segment: The name of the tables can be changed in the SQL Server database by tapping on the name in the Destination section: 6 At the point when the appropriate sections are set, tap on Next catch.
7 Simply Run the Package and you’re done.