Import Data From Excel Sheet to Database!

Question

Dear Team As Its My First Question please Help. My Question Is: m able to insert data from excel to database using c# window form.But M not able to track each transaction on insert query to get live update at run time . at the end it show numbers of data uploaded. Is it Possible to get rejection of data from excel and validate error on each row of excel data. Thanks In Advance(Team)

Karthik Elumalai · Answer

Hi Siraj khan You can use the two below efficient ways to read an Excel files and import data to anywhere. http://www.c-sharpcorner.com/article/read-excel-files-using-open-xml-sdk-in-asp-net-c-sharp/ http://www.c-sharpcorner.com/blogs/read-excel-files-using-microsoft-office-interop-assemblies-in-asp-net-c-sharp In the above articles myself mentioned that the basics of how we can easily read the data from the excel. Kindly let me know if need more information. thanks karthik

Jeetendra Negi · Answer

if you want it from RDBMS(SQL server) then see following link http://www.66pacific.com/sql_server_import_from_excel.aspx and if you want it from programmatically then see following link http://www.codeproject.com/Tips/636719/Import-MS-Excel-data-to-SQL-Server-table-using-Csh

Nilesh Sawardekar · Answer

You can use for loop to insert data and use if else for checking. but that will be time consuming.

Amit Kumar · Answer

Hi Dear Please follow the given link. It will help more you. https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/ Regards Amit