Click here to Skip to main content
15,891,951 members
Please Sign up or sign in to vote.
2.33/5 (3 votes)
See more:
Hi i am facing the problem of data of excel file import in sql DATABASE TABALE .
please give me valuable guidance with C# code & Example
Posted

this method work well,
customised this according to you:

Import Data from Excel to SQL Server[^]
 
Share this answer
 
You have several possibilities:
1) using just the sql server facilities: http://support.microsoft.com/kb/321686[^]
2) Using data access on client side: Import Data from excel to SQL server using C# in ASP. NET[^].
Some remarks on this:
- it is not only for asp.net
- don't use string concatenation for dml statement generation, use parameterized command[^] instead or EntityFramework
3) Bulk copy: http://technico.qnownow.com/bulk-copy-data-from-excel-to-destination-db-using-sql-bulk-copy/[^]
4) Interop: http://dontbreakthebuild.com/2011/01/30/excel-and-c-interop-with-net-4-how-to-read-data-from-excel/[^], Faster MS Excel Reading using Office Interop Assemblies[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900