Search code examples
sql-serversql-server-2008excelc#-4.0import-from-excel

Import data directly from Excel sheet into SQL Server table

I have multiple table's data in single Excel sheet with exact column names, now I want to insert that data into my SQL Server 2008 tables.

For example: I have one table Student which has columns Stud_ID, Stud_Name, Branch, Status.

And same as, I have one Excel sheet Student which has columns Stud_ID, Stud_Name, Branch, Status. Excel sheet has multiple records of data in it.

Now I want to insert that data into the SQL Server table Student.

How can I do that using C# coding and without coding (directly Excel to SQL Server database)? Please guide me its urgent.

Thanks.

Solution

  • Check Import Data from excel to SQL server using C# in ASP. NET for doing the same using C#

    check How to import an Excel file into SQL Server 2005 using Integration Services for directly importing Excel data to Sql Server.