Import Multiple Excel Files to SQL Table

Question

Dear all friends How to import multiple excel files to sql server table using c# languages...

Vipan Sharma · Answer

If number and type of columns are same in every excel. So not a big issue. Use loop for reading multiple files.

Vipan Sharma · Answer

Hello  Very good example are below  http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/ http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx Try this

Amit Kumar · Answer

Hi use it.. http://www.dotnetfox.com/articles/import-records-from-excel-sheet-to-sql-server-with-validations-in-Asp-Net-using-C-Sharp-1052.aspx http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

Ravi Patel · Answer

Hi  check this http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx https://www.youtube.com/watch?v=6J24aI2LVoY

Yogesh Sharma · Answer

Thanks for your reply... This was the single file only but we have multiple files in single folder.. So what we have to done to achieve this type of task... Thank you....

Amit Singh · Answer

Hey refer this link 1.http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx