Import Multiple Excel Files to SQL Table

Accepted answer

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

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

Hi ,

check this

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....

Hey, refer this link

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

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