Import Data From Excel Sheet to Database!

siraj Khan

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),

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karthik Elumalai10y ago
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 Negi10y ago
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 Sawardekar10y ago
You can use for loop to insert data and use if else for checking. but that will be time consuming.
Amit Kumar10y ago
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